Never, Never save to a floppy (Corruption)

Why not add the date to the file name
"C:\MYLAR_001 " & Format(Now, "dd-mm-yy h-mm-ss") & ".xls"



--
Regards Ron de Bruin
http://www.rondebruin.nl


"ufo_pilot" wrote in message ...
I need to save to a floppy a
Worksheet that is copied daily from a master
then it needs to be saved ( not necessarily to a floppy just for now until
we hook up the PC to a network and printer)
But I would like for the workbook to be saved automatically (upon a "DONE"
button, and not overwirte the previous one.
This code will prompt to overwrite the previous file.


ActiveWorkbook.SaveAs FileName:="A:\MYLAR_001.xls", FileFormat:=xlNormal, _
Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _
CreateBackup:=False