Quote Originally Posted by Leith Ross View Post
Hello spiwere,

The attached workbook has the macro below added to it along with a button on the worksheet to run it. You did not say what the parent folder was. The default parent folder location is "My Documents". The user can select a different folder when the macro is run.

[End Sub
[/code]
Thanks once again for offering to help me out. But I'm somehow unable to execute the code. This is what I have changed:

 ParentFolder = ssfPersonal  ' Constant points to My Documents. This can also be a string like "C:\Users\Owner" - to

ParentFolder = "C:\Users\ABC\Desktop\Renaming\Spi"
On running the code in it shows a message that files were copied and renamed in a sub-folder, but no files are found in the new folder that was created....

Also, my apologies in case I wasn't clear in my request. My spreadsheet only has Columns B, C, D and E.

The original file names in Column A and requested file name in column F are not a part of the spreadsheet. These were purely given to help understand my request. I would like the macro to read the Unique ID from Column B of the spreadsheet select the file from the Parent folder which has the same ID, and then create a copy with the new naming convention.

Hope this clarifies my problem. Once again apologies if I wasn't clear in the first instance.

Please advise.