Batch rename files with data from excel sheet

[srk999]

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.

[Yzöwl]

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.