I have a spreadsheet that has the names of a bunch of files in a folder currently in column A. I want to rename them by what i want as their new names in column C. So, can I use a macro to search a folder for the original name, and replace it with the new name in Column C. We'll say the folder filepath is N:\Accounting\Financial Analysis\2010 Budgets. The translate sheet, with the old and new names will be called "Translate Sheet" in the same folder.

Thanks for your help!