Hi All,
I have the need to take a list of files named in an Excel spreadsheet and rename them.
Column A has the file names as they stand. All files are in a single directory.
Column B has the corresponding names that I want to convert the files to. I.E. A1=oldname.jpg A2=newname.png.
What would be the code required to automatically rename the files from column A to the filenames in column B?
In brief; I need to locate each named file in column A within a named directory and rename each file found with the name held in the adjacent cell in column B.
Many thanks!
Jimbo
I have the need to take a list of files named in an Excel spreadsheet and rename them.
Column A has the file names as they stand. All files are in a single directory.
Column B has the corresponding names that I want to convert the files to. I.E. A1=oldname.jpg A2=newname.png.
What would be the code required to automatically rename the files from column A to the filenames in column B?
In brief; I need to locate each named file in column A within a named directory and rename each file found with the name held in the adjacent cell in column B.
Many thanks!
Jimbo