Putting Data & Time in file name

rglasunow · #1 07-07-2005, 08:21 PM

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!!!

#2 07-07-2005, 10:05 PM

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
>

rglasunow · #3 07-08-2005, 03:37 PM

Unfortunately that did not work. The only thing it did was add 6 zeros after the date. I also tried hh:mm:ss and that didn't work either. Any other suggestions in putting the current time into the file name?

thanks again!

Norie · #4 07-08-2005, 03:51 PM

Instead of date use Now.

Code:

Format(Now, "mm-dd-yyyy hhmmss")

Welcome to the Excel Forum

Forum Statistics