Excel 2007 : Batch Rename Files with Excell 2007?

Fellow Forum Members,
I have searched the past threads with no success.

I'm using 2007 Excel and I have a list of 200 JPG files on column A which mirror actual file names of files I have located in C:\photos.

My objective is to use Excel 2007 to batch rename all the files located in C:\photos from the names listed in column "A" to the names listed in column "B" that I have created.

Can anyone out there help me out with a VBA script that will accomplish this task? Any help will be greatly appreciated. Thanks.

Try this (completely untested, so ...)

Please Login or Register  to view this content.

Shq,
Thanks for the script. It works Beautifully! I was not looking forward to renaming all of those files manually. Thanks for the help. You have saved me from having to perferm a very tedious task.

You’re welcome. Would you please mark the thread as Solved?

Click the Edit button on your first post in the thread

Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes