software

Im racking my brain here trying to figure out a way to build a macro
that will save a spreadsheet as a date and time. Anyone have a
solution?

Basicly I want to have a macro thats move the current data out of one
wook sheet to another wook book and save it. The file name will have to
change everytime this happens. Perferably the date and time. Its this
unique file name that Im stuck on.--
Tasar
------------------------------------------------------------------------
Tasar's Profile: www.excelforum.com/member.php...oamp;userid=30272
View this thread: www.excelforum.com/showthread...hreadid=499401Activeworkbook.saveas _
filename:=quot;C:\test\quot; amp; format(now,quot;yyyy_mm_dd__hh_mm_ssquot;) amp; quot;.xlsquot;

You don't need to get the date/time out of a worksheet.
Tasar wrote:
gt;
gt; Im racking my brain here trying to figure out a way to build a macro
gt; that will save a spreadsheet as a date and time. Anyone have a
gt; solution?
gt;
gt; Basicly I want to have a macro thats move the current data out of one
gt; wook sheet to another wook book and save it. The file name will have to
gt; change everytime this happens. Perferably the date and time. Its this
gt; unique file name that Im stuck on.
gt;
gt; --
gt; Tasar
gt; ------------------------------------------------------------------------
gt; Tasar's Profile: www.excelforum.com/member.php...oamp;userid=30272
gt; View this thread: www.excelforum.com/showthread...hreadid=499401

--

Dave Peterson