Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ActiveWorkbook.SaveAs problem | Excel Programming | |||
Max charactors for 'ActiveWorkbook.SaveAs Filename'? | Excel Worksheet Functions | |||
'ActiveWorkbook.SaveAs Filename' | Excel Programming | |||
ActiveWorkbook.SaveAs Problem | Excel Programming | |||
activeworkbook.saveas | Excel Programming |