Thread: Save file with time date stamp
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
oberon.black[_91_] oberon.black[_91_] is offline
external usenet poster
  
Posts: 1
Default Save file with time date stamp

I have this code


Code:
--------------------

ActiveWorkbook.SaveAs Filename:="c:\t\q1\blue\save\"filename""

--------------------


I want the 'filename to be todays time and date.

How do I make this happen?


--
oberon.black
------------------------------------------------------------------------
oberon.black's Profile: http://www.excelforum.com/member.php...o&userid=26732
View this thread: http://www.excelforum.com/showthread...hreadid=469731

Reply With QuoteReply With Quote