Question

How to save a document as current date ?

Microsoft Excel, VBA, Excel macros, Excel 2000, Visual Basic for Applications

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

You can use the Date$ function to get a String of format mm-dd-yyyy. You can then use this string with the Workbook.Close Workbook.SaveAs, etc. EG:

function saveWithDate(myWorkbook as Workbook)
     Dim dateStr as String
     dateStr = Date$
     myWorkbook.SaveAs FileName:=dateStr & ".xls"
 end function