Macro to auto save file using the format YYMM

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I recorded a macro that automatically saves a file then change the formula
in cell A1 to today's date, ie =today(), then save the file. I have a problem
with the last part...is there any way I can set the macro such that the file
will be saved as "c:\YYMM ABC" where 'YYMM' is the format of the date
(probably can be taken from cell A1) and 'ABC' is my own file name?

Thanks!
 
You can get the date right in the code:

dim myFileName as string
myfilename = "C:\" & format(date,"yymm") & " ABC.xls"

activeworkbook.saveas filename:=myfilename, fileformat:=xlworkbooknormal
 

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

Saving file in the format "YYMM" 2
Date formating yymm 2
Macro to create a new folder according to the month 4
Excel date format trouble 2
Save as a new format name automatically 2
Help to create a macro 2
problems getting this macro to work 23
macro to print xps then save with name value in (B2) 8

Back
Top