File Name as Date and Time

  • Thread starter Thread starter Tasar
  • Start date Start date
T

Tasar

Im racking my brain here trying to figure out a way to build a macro
that will save a spreadsheet as a date and time. Anyone have a
solution?

Basicly I want to have a macro thats move the current data out of one
wook sheet to another wook book and save it. The file name will have to
change everytime this happens. Perferably the date and time. Its this
unique file name that Im stuck on.
 
Activeworkbook.saveas _
filename:="C:\test\" & format(now,"yyyy_mm_dd__hh_mm_ss") & ".xls"

You don't need to get the date/time out of a worksheet.
 
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

file save as 5
Numbers in work sheet not Formating right 1
Save File in Desired Location & Name 2
Anyone familair with Documentum Webtop and running Excel macros? 0
Pivot table macro filter data between yesterday and today (date+time) 0
How do I save a spreadsheet from a macro? 2
Save file as todays date 3
Save as a new format name automatically 2

Back
Top