Help With Macro
Public Sub SaveAsDate()
ActiveWorkbook.SaveAs Filename:= CStr(Format(Now, "mmmm dd yyyy")
End Su
----- Keven wrote: ----
I have written an excel 2003 macro that imports a comma
delimited text file and makes a couple of basic formating
changes to it. what I would like to do is find a way that
I could save this file with a file name of (current
date).xls any help with this would be greatly appreciated
Thanks
Keve
|