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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
save & backup file
Try
Application.DisplayAlerts = False 'SaveAs code Application.DisplayAlerts = True -- If this post helps click Yes --------------- Jacob Skaria "Seeker" wrote: 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 |
Reply |
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) |