photon_ed
05-20-2006, 10:06 AM
Hello,
simple question, I would like to save the "TESTING.xls" workbook as "TESTING 5/20/2006.xls" or "TESTING 5thMay2006". I tried using "I:\TESTING" & Date ".xls" and "I:\TESTING.xls" & Date, but obviously excel didnt like it and refuse to do so. Can someone please advise.
Thank you
Yours,
Ed
sub newWorkbook()
Workbooks.Add
ActiveWorkbook.SaveAs Filename:= _
"I:\TESTING.xls", FileFormat:=xlNormal, _
Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _
CreateBackup:=False
end sub
simple question, I would like to save the "TESTING.xls" workbook as "TESTING 5/20/2006.xls" or "TESTING 5thMay2006". I tried using "I:\TESTING" & Date ".xls" and "I:\TESTING.xls" & Date, but obviously excel didnt like it and refuse to do so. Can someone please advise.
Thank you
Yours,
Ed
sub newWorkbook()
Workbooks.Add
ActiveWorkbook.SaveAs Filename:= _
"I:\TESTING.xls", FileFormat:=xlNormal, _
Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _
CreateBackup:=False
end sub