Copy Folder then rename files in new folder from list in Excel

[jimjones1958]

Hello,

I am attempting to copy a folder and then rename the files in the copied folder with a list derived from an excel workbook. In the excel workbook, column A contains the original name, and Column B contains the new name. Here is a snapshot of the naming "from" and "to" cells:

2021-04-19_16-41-33.png

This code that I have so far just copies the folder. I need to now rename the files as determined by the list given above.

Please Login or Register  to view this content.

[cubangt]

Here is some logic found elsewhere, step thru the code and make sure that you are passing the correct "path"/ "filename" into the line that names

Please Login or Register  to view this content.

[jimjones1958]

Hello,

Thanks for your response.

Where do I insert your code?

I tried the code below but could not get it to work:

Please Login or Register  to view this content.

[cubangt]

Depends when you want to rename the files..
You can call it separately and let it rename the files based on a folder
Or you can call the rename right after your copy line, but you would need to update the routine to accept the path and file name for it to work.

Please Login or Register  to view this content.