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 |
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 |