Here's the situation:
I have an excel file which contains the following information:
Document location: (C:/folder/sub/file.doc)
and Document New Name: (RENAMED-FILE.doc)
What would be the be the best way to automate this as I have about a thousand files to rename?
*Note: Document location can be in different locations (files will not always be inside folder/sub) Document new name has no naming convention.
So basically, everything has to come from the excel file, or I have to change the excel file into something (maybe a CSV file?) to have it work with another utility.
Any suggestions?