How to save a document as current date ?
I'm using VBA in excel 2000 to create a macro that saves out a spreadsheet with today's current date. I cannot figure out the code that will achieve this function. Help Please
Software/Hardware used:
Software/Hardware used:
ASKED:
April 22, 2008 7:15 PM
UPDATED:
April 22, 2008 8:30 PM
Answer Wiki:
You can use the Date$ function to get a String of format <i>mm-dd-yyyy</i>. You can then use this string with the Workbook.Close Workbook.SaveAs, etc. EG:
<pre>function saveWithDate(myWorkbook as Workbook)
Dim dateStr as String
dateStr = Date$
myWorkbook.SaveAs FileName:=dateStr & ".xls"
end function</pre>
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
