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?action=getinfo&userid=4212
View this thread: http://www.excelforum.com/showthread.php?threadid=385436

.

Relevant Pages

  • Formating Font in a Formuls
    ... I would also like both to be bold. ... Silvanus ... Silvanus's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29515 ... Prev by Date: ...
    (microsoft.public.excel.newusers)
  • Adding times
    ... The problem lies in the part of the function marked in bold. ... mel_flynn's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29206 ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • Adding times
    ... The problem lies in the part of the function marked in bold. ... mel_flynn's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29206 ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Re: Automatic top of sheet?
    ... Your answer stopped me from going bold:) ... bowe's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=27110 ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • Re: Putting Data & Time in file name
    ... The only thing it did was add 6 zeros ... rglasunow's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=4212 ... Prev by Date: ...
    (microsoft.public.excel.programming)
Loading