ActiveWorkbook.SaveAs FileName;= 'sequential
 

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

ActiveWorkbook.SaveAs FileName;= 'sequential
 

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

ActiveWorkbook.SaveAs FileName;= 'sequential
 

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.

"Ron de Bruin" wrote:

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