Renaming files in bulk

Hi all,

I am trying to create a macro that will rename all files in column A according to the names in column B. Let us assume that names already include the full path and are not necessarily in the same folders such as:

• Column A - C:\Users\me\Desktop\Experience\A1.docx (without "")
• Column B - C:\Users\me\Desktop\Experience\B1.docx (without "")

I would like to do something like this:

Please Login or Register  to view this content.

All inputs are appreciated. As you can see, I'm admittedly a beginner.

Hi Leith,

Thanks for the content. It does work indeed - not sure what happened yesterday. May I take the chance to ask for your help taking this a bit further: what would be an alternative to the Name statement in order to create new files/ directories as required by column B inputs? I have made slight changes:

Please Login or Register  to view this content.