Thread: Save File with the current date and time.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
  
Posts: 5,302
Default Save File with the current date and time.
Hi SD,

Try:

'=============
Public Sub Tester04A()

ActiveWorkbook.SaveAs _
Filename:=Format(Now, "yyyymmdd hh-mm") & ".xls", _
FileFormat:=xlWorkbookNormal

End Sub
'<<=============


---
Regards,
Norman


"sd" wrote in message
ups.com...
How can I save a file with the file name as the current date and time?



Reply With QuoteReply With Quote