| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
save & backup file
I have following code recorded, how could I
1) save workbook without message box prompt to overwrite the existing file name 2) synchronization content in backup file ActiveWorkbook.SaveAs Filename:= _ "C:\Documents and Settings\Don\My Documents\Book1.xls", FileFormat:=xlNormal _ , Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _ CreateBackup:=True ActiveWorkbook.Close (True) Rgds |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Turning always save backup file to off | Setting up and Configuration of Excel | |||
| always save backup | Setting up and Configuration of Excel | |||
| Where does Save As Automatic Backup save its files? | Excel Discussion (Misc queries) | |||
| In Excel, I want to create a backup copy whenever I save a file. | Excel Discussion (Misc queries) | |||
| How do I shut off making a backup copy of a file when I save in E. | Excel Discussion (Misc queries) | |||
Threaded Mode
