Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Replace File
I cannot determine how to write the language to overwrite
an existing file when performing "active workbook, file save as". I have the following code and would like for the macro to answer "yes" for replacing the current file, but I do not know how to write it. ActiveWorkbook.SaveAs FileName:="C:\Temp\2003 Trial\data.xls" _ , FileFormat:=xlExcel5, Password:="", WriteResPassword:="", _ ReadOnlyRecommended:=False, CreateBackup:=False Thank you for your help, Kimberly |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Replace File
Application.DisplayAlerts = False
ActiveWorkbook.SaveAs FileName:= _ "C:\Temp\2003 Trial\data.xls" _ , FileFormat:=xlExcel5, Password:="", _ WriteResPassword:="", _ ReadOnlyRecommended:=False, CreateBackup:=False Application.DisplayAlerts = True Regards, Tom Ogilvy "Kimberly" wrote in message ... I cannot determine how to write the language to overwrite an existing file when performing "active workbook, file save as". I have the following code and would like for the macro to answer "yes" for replacing the current file, but I do not know how to write it. ActiveWorkbook.SaveAs FileName:="C:\Temp\2003 Trial\data.xls" _ , FileFormat:=xlExcel5, Password:="", WriteResPassword:="", _ ReadOnlyRecommended:=False, CreateBackup:=False Thank you for your help, Kimberly |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Book1.XLS replace by old file name | Excel Discussion (Misc queries) | |||
Replace All makes me look for a file! | Excel Discussion (Misc queries) | |||
file replace | Excel Discussion (Misc queries) | |||
how do set excel up to auto replace a file? | Excel Discussion (Misc queries) | |||
If I accidently replace a saved file can I retrieve the old file? | Excel Discussion (Misc queries) |