Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save date in filename
Hi. I would like to have the current date saved in the
filename when the macro is excercised. For instance, the filename is "Log File.xls". I would like a command that, if executed on February 23, it would save the filename "Log File - 2/23/04.xls. My current command is: ActiveWorkbook.SaveAs Filename:=ThisWorkbook.Path & "\Archive\" & "Log File" What should I add to this command to include the date? Thanks, Mike. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save date in filename
"Log file-" & Date
-- Regards; Rob ------------------------------------------------------------------------ "Mike" wrote in message ... Hi. I would like to have the current date saved in the filename when the macro is excercised. For instance, the filename is "Log File.xls". I would like a command that, if executed on February 23, it would save the filename "Log File - 2/23/04.xls. My current command is: ActiveWorkbook.SaveAs Filename:=ThisWorkbook.Path & "\Archive\" & "Log File" What should I add to this command to include the date? Thanks, Mike. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save date in filename
Rob:
Thanks for your reply. When I try this, I get a run time error. It says it cannot access the file .... \Archive\Log File-2\23. It appears as if it is treating the slashes in the date as directory paths ... Any ideas? Thanks, Mike. -----Original Message----- "Log file-" & Date -- Regards; Rob --------------------------------------------------------- --------------- "Mike" wrote in message ... Hi. I would like to have the current date saved in the filename when the macro is excercised. For instance, the filename is "Log File.xls". I would like a command that, if executed on February 23, it would save the filename "Log File - 2/23/04.xls. My current command is: ActiveWorkbook.SaveAs Filename:=ThisWorkbook.Path & "\Archive\" & "Log File" What should I add to this command to include the date? Thanks, Mike. . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save date in filename
-- Regards; Rob ------------------------------------------------------------------------ "Mike" wrote in message ... Rob: Thanks for your reply. When I try this, I get a run time error. It says it cannot access the file .... \Archive\Log File-2\23. It appears as if it is treating the slashes in the date as directory paths ... Any ideas? Thanks, Mike. -----Original Message----- "Log file-" & Date -- Regards; Rob --------------------------------------------------------- --------------- "Mike" wrote in message ... Hi. I would like to have the current date saved in the filename when the macro is excercised. For instance, the filename is "Log File.xls". I would like a command that, if executed on February 23, it would save the filename "Log File - 2/23/04.xls. My current command is: ActiveWorkbook.SaveAs Filename:=ThisWorkbook.Path & "\Archive\" & "Log File" What should I add to this command to include the date? Thanks, Mike. . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save date in filename
Oops, it's past my bedtime!
Paul is correct, and my only excuse is that my date separator is set up as a dash, so out of habit I ignored the slash in your example. Sorry for the confusion. -- Regards; Rob ------------------------------------------------------------------------ "Mike" wrote in message ... Rob: Thanks for your reply. When I try this, I get a run time error. It says it cannot access the file .... \Archive\Log File-2\23. It appears as if it is treating the slashes in the date as directory paths ... Any ideas? Thanks, Mike. -----Original Message----- "Log file-" & Date -- Regards; Rob --------------------------------------------------------- --------------- "Mike" wrote in message ... Hi. I would like to have the current date saved in the filename when the macro is excercised. For instance, the filename is "Log File.xls". I would like a command that, if executed on February 23, it would save the filename "Log File - 2/23/04.xls. My current command is: ActiveWorkbook.SaveAs Filename:=ThisWorkbook.Path & "\Archive\" & "Log File" What should I add to this command to include the date? Thanks, Mike. . |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save date in filename
ActiveWorkbook.SaveAs Filename:=ThisWorkbook.Path
& "\Archive\" & "Log File " & format(date,"mmddyy") & ".xls" Or one of the combinations below to start. format(date,"mmm dd yyyy") format(date,"mm dd yy") format(date,"mm dd yyyy") When I append dates, I don't fool around with backslashes or slashes. HTH Paul -------------------------------------------------------------------------------------------------------------- Be advised to back up your WorkBook before attempting to make changes. -------------------------------------------------------------------------------------------------------------- Hi. I would like to have the current date saved in the filename when the macro is excercised. For instance, the filename is "Log File.xls". I would like a command that, if executed on February 23, it would save the filename "Log File - 2/23/04.xls. My current command is: ActiveWorkbook.SaveAs Filename:=ThisWorkbook.Path & "\Archive\" & "Log File" What should I add to this command to include the date? Thanks, Mike. |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save date in filename
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell("filename") doesn't update to new filename when do save as. | Excel Worksheet Functions | |||
set filename to <filename-date on open | Excel Worksheet Functions | |||
Save as .htm with filename from cell | Excel Discussion (Misc queries) | |||
Disabling Macros After A Save To A Different Filename | Excel Programming | |||
Save Filename+Date+Time? | Excel Programming |