Excel 2007: Batch Rename files

[shurnicemora]

Hello all,
I appreciate any assistance that you can lend. Basically, I am trying to rename a lot of files within 1 folder. The Spreadsheet Column A contains all the old file names within a folder and Column B has the new file name. (1)My code is below but I continue getting an error that the file isn't found. (2) I would like to start with row 2 because row 1 will contain the folder path as a result of another macro.

Please note, the code below is a result of searching the forum and adapting for my need.

Please Login or Register  to view this content.

[mrice]

I suspect that you might need a terminating backslash character in your constance definition.

[shurnicemora]

Thank you so much for the quick reply - the backslash worked like a charm