Macro to rename excel file

[motosid]

Hi All ,

Can anybody tell me how to rename the excel file using an macro

OLD name : US Projector WAPP report - December 2013.xlsm
want to replace it with

NEW name :US Projector WAPP report - January 2014.xlsm

Please Help!

 

[alow]

are you looking to change the date in the name on a large group of files? Or copy the files with a new name and date? If you want to rename them all and just replace the date part, you could do this more easily with a Windows batch file. If you can provide a bit more insight into what you are looking to accomplish, I or someone can likely help you out.