|
Re: Putting Data & Time in file name
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" <rglasunow.1rtqmy_1120781133.2984@excelforum-nospam.com> wrote
in message news:rglasunow.1rtqmy_1120781133.2984@excelforum-nospam.com...
>
> 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
>
|