Try:
Format(Date, "mm-dd-yyyy hhmmss")
--
Damon Longworth
Don't miss out on the 2005 Excel User Conference
Sept 16th and 17th
Stockyards Hotel - Ft. Worth, Texas
www.ExcelUserConference.com
"rglasunow" wrote
in message ...
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