Thread: Putting Data & Time in file name
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
rglasunow[_24_] rglasunow[_24_] is offline
external usenet poster
  
Posts: 1
Default 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!!!


--
rglasunow
------------------------------------------------------------------------
rglasunow's Profile: http://www.excelforum.com/member.php...fo&userid=4212
View this thread: http://www.excelforum.com/showthread...hreadid=385436

Reply With QuoteReply With Quote