Thread: Putting Data & Time in file name
View Single Post
  #1  
Old 07-07-2005, 08:21 PM
rglasunow rglasunow is offline
Registered User
  
Join Date: 24 Dec 2003
Posts: 15
rglasunow is becoming part of the community
Putting Data & Time in file name
I would like to add the time to the file name along with the date that I currently have in the file name.

I currently have the date in the code below in bold. How can I add the current time as well?

ActiveWorkbook.SaveAs Filename:="C:\SOS Data\Compiled Data\SOS Data - " & Format(Date, "mm-dd-yyyy") & ".xls"

Thanks ya'll!!!
Reply With Quote