Save Filename+Date+Time?

S

Scooby912

Is it possible to automatically, with macro or vb, save a currently open
file with the (filename+date+time) to create a new file?

Example:
File1.xls (currently open)
File1mmddyyhhmmss.xls (newly created file)

Thanks,
Erwin
 
C

Chip Pearson

Erwin,

Try

ActiveWorkbook.SaveAs _
"FileName" & Format(Now,"mmddyyhhmmss") & ".xls"


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 

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 a bakup file when opening the file 3
VBA - exporting serial letters to single documents 0
how do i loop thru all the worksheets in 2 files one by one 0
How to code it on macro ? 10
Word macro that can call cells out of Excel for a find and replace 0
Referencing a cell value in a macro 7
MACRO to save current worksheet with variable filename 1
Difficulty with compatibility mode and Track Changes 2

Top