ActiveWorkbook.SaveAs FileName;= 'sequential

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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"
 
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.
 
Back
Top