Automatically saving worksheet by the date

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

How do I make a macro to save my worksheets by date(Apr
14,2004 and so on)?.
 
Hi
in your macro something like
dim fname
fname = format(date,"MMM_DD_YYYY") & ".xls"
activeworkbook.saveas filename:=fname
 
You must log in or register to reply here.

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

"save as" 0
Complex VLookup Formula 2
Close all without saving and exit without prompts 8
table lookup 5
Weekending Function 5
Summing over multiple worksheets 1
VlOOKUP/MATCH/INDEX 2
Calculate End Date Using Start Date and No. of Days excluding specific days. 0

Back
Top