Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
File Name as Date and Time
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: http://www.excelforum.com/member.php...o&userid=30272 View this thread: http://www.excelforum.com/showthread...hreadid=499401 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
File Name as Date and Time
Activeworkbook.saveas _
filename:="C:\test\" & format(now,"yyyy_mm_dd__hh_mm_ss") & ".xls" You don't need to get the date/time out of a worksheet. Tasar wrote: 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: http://www.excelforum.com/member.php...o&userid=30272 View this thread: http://www.excelforum.com/showthread...hreadid=499401 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help: convert seconds to date and time | Excel Discussion (Misc queries) | |||
How to calculate Date & Time differences | Excel Worksheet Functions | |||
Using VLOOKUP with a Date and Time | Excel Discussion (Misc queries) | |||
How do I calculate if a date is in a certain time frame? | Excel Worksheet Functions | |||
Imported Date & Time format with calcs. managed in excel from imrp | Excel Worksheet Functions |