Save as "date"

  • Thread starter Thread starter spinner
  • Start date Start date
S

spinner

does anyone knows how to save an excel file with the date of today? needs to
work automaticly everyday
Any ideas?
 
Hi
from within VBA you may use something like
sub save_date()
Dim fname
fname = "mybook" & format(now,"YYYYMMDDHHSS")
fname = fname & ".xls"
ActiveWorkbook.SaveAs Filename:=fname
end sub

Though this is NOT automatic.
 
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

How to save EXCEL file at specified datetime, say at midnight 00:0 1
Which is the best MBOX Converter Tool different formats conversion? 4
Saving worksheet as a text file 7
Excel Excel Show Countdown Date 7
Create Excel Lab test results 1
Save Button in Excel 2
Conditional Validation In Excel 1
Save file with different names 3

Back
Top