I have a bunch of files, with a solid prefix and a random numer. These files are listed in an excel sheet.
The sheet has a few row's. Next to the row witch contains the original file name, is a second row, containing extra information about the file and that information must become part of the filename.
Is there a way to read out the second row of the excel sheet and apply the data in that cell to the file - names i have?
This is about 10000+ files, so i would be glad if this is something I don't have to do by hand
So what must happen is that some program makes a file list, then compares the file list with the file names in ms excel in row 1, then paste the information in the second row to the file name.
For more information ask me!
Thanks in advance!