Posted to microsoft.public.excel.programming

oberon.black[_91_] oberon.black[_91_] is offline

external usenet poster

Posts: 1

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 Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
product date stamp file save	Robert Loxley	Excel Discussion (Misc queries)	12	November 13th 06 02:48 PM
Save File with Date and Time Stamp	Andibevan[_3_]	Excel Programming	9	May 4th 06 01:17 AM
Date Stamp Save	oberon.black[_29_]	Excel Programming	2	September 10th 05 06:17 PM
Save as w/ Time Stamp	Arturo	Excel Programming	2	February 22nd 05 12:49 AM
Getting a File Date & Time stamp	James	Excel Programming	5	February 8th 05 07:15 PM

All times are GMT +1. The time now is 05:41 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us