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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

PowerPoint Change/update links to new source (PPT with charts & objects linked to Excel) 1
Microsoft's new CEO is Satya Nadella 3
Change excel file name by macro 4
Excel Excel VBA BeforeSave 0
Advanced filter on last months results 6
Macro to rename Tab and then save as 2
How to convert decimal year to date format in excel 2
Show actual name of file path after you have renamed it 3

Back
Top