srk999 Posted November 12, 2009 Share Posted November 12, 2009 I need to batch rename files with data from a excel sheet. The files are old financial records. The excel sheet, among many other data has their titles and corresponding date (year). The files already have the titles as names. I need to put the dates in the name of the files. Really hope someone can help me with this. Link to comment Share on other sites More sharing options...
Yzöwl Posted November 12, 2009 Share Posted November 12, 2009 Without more information I cannot really provide a solution. What you'll need to do is to 'save as' your Excel file to csv. Then we'll need to see an example output from that file which should show us a full line of that csv output. This will give us the positions and format of the information you need to use, i.e. the Title and Date, in order to formulate the required code.Additionally, it may be a good idea to provide us an idea of the sizes/number of lines in these csvs, because size alone may indicate that a vbscript is a far quicker to process than a batch file. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now