ActiveWorkbook.SaveAs FileName;= 'sequential

[Guest]

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

 

[Ron de Bruin]

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"

 

[Guest]

Yes, Ron you are of course correct
I have decided to save it to C:\
all it was is a Master > copied and saved as...
Thanks to your help this is now an easy task.
Thanks again for your time spent to help not ony myself, but many, many
others here.