Macro to rename excel file

M

motosid

Joined
Dec 18, 2013
Messages
1
Reaction score
0
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!
 
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.
 
Back
Top