Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Automatic File Saving
Hello, I need a macro that will automatically save an excel file, with a unique file name each time, it would be good if it could put the date and time into the file name. If its not possible to put the date and time into the file name, then just generating a unique file name will be enough. How would I go about doing this ? Regards Stephen -- smoran ------------------------------------------------------------------------ smoran's Profile: http://www.excelforum.com/member.php...o&userid=27753 View this thread: http://www.excelforum.com/showthread...hreadid=472964 |
#2
|
|||
|
|||
dim myFileName as string
myfilename = "C:\" & format(now,"yyyymmdd_hhmmss") & ".xls" Activeworkbook.saveas filename:=myfilename, fileformat:=xlworkbooknormal Or something like that. smoran wrote: Hello, I need a macro that will automatically save an excel file, with a unique file name each time, it would be good if it could put the date and time into the file name. If its not possible to put the date and time into the file name, then just generating a unique file name will be enough. How would I go about doing this ? Regards Stephen -- smoran ------------------------------------------------------------------------ smoran's Profile: http://www.excelforum.com/member.php...o&userid=27753 View this thread: http://www.excelforum.com/showthread...hreadid=472964 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I recover deleted entries after saving a file? | Excel Discussion (Misc queries) | |||
saving file as text(tab delimited)... | Excel Discussion (Misc queries) | |||
How do I stop Excel 2000 from saving file history from file that . | Excel Discussion (Misc queries) | |||
saving excel file as tab delimited | Excel Discussion (Misc queries) | |||
Saving a Excel 97 file into Excel 2003 file | Excel Discussion (Misc queries) |