| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
overwriting a file
i have code written in VBA and at the end of the code i have this
ChDir "E:\Joss Blaze\temp" ActiveWorkbook.SaveAs Filename:="E:\Joss Blaze\temp\temp.xls", FileFormat:= _ xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False _ , CreateBackup:=False MsgBox "Extraction Successful Proceed To Access", vbInformation, "Info." ActiveWorkbook.Close Application.Quit Excel.Application.Quit can anyone tell me how to overwrite the temp file automaticallywith out having to click yes while the messege "this files already exists do you want to overwrite...." thank you jordan |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
overwriting a file
i got an error messege which is
Run-time error '438': Object doesn't support this property or method what can i do now "Frank Kabel" wrote in message ... Hi try application.displayevents=false 'your code application.displayevents=true -----Original Message----- i have code written in VBA and at the end of the code i have this ChDir "E:\Joss Blaze\temp" ActiveWorkbook.SaveAs Filename:="E:\Joss Blaze\temp\temp.xls", FileFormat:= _ xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False _ , CreateBackup:=False MsgBox "Extraction Successful Proceed To Access", vbInformation, "Info." ActiveWorkbook.Close Application.Quit Excel.Application.Quit can anyone tell me how to overwrite the temp file automaticallywith out having to click yes while the messege "this files already exists do you want to overwrite...." thank you jordan . |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
overwriting a file
Hi
try application.displayevents=false 'your code application.displayevents=true -----Original Message----- i have code written in VBA and at the end of the code i have this ChDir "E:\Joss Blaze\temp" ActiveWorkbook.SaveAs Filename:="E:\Joss Blaze\temp\temp.xls", FileFormat:= _ xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False _ , CreateBackup:=False MsgBox "Extraction Successful Proceed To Access", vbInformation, "Info." ActiveWorkbook.Close Application.Quit Excel.Application.Quit can anyone tell me how to overwrite the temp file automaticallywith out having to click yes while the messege "this files already exists do you want to overwrite...." thank you jordan . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
overwriting a file
"Frank Kabel" wrote in message ... Hi try application.displayevents=false 'your code application.displayevents=true I think you mean Application.DisplayAlerts NOT displayevents Keith |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
overwriting a file
Hi
as Keith already mentions I used the wrong name. Make this application.displayalerts = ... -----Original Message----- i got an error messege which is Run-time error '438': Object doesn't support this property or method what can i do now "Frank Kabel" wrote in message ... Hi try application.displayevents=false 'your code application.displayevents=true -----Original Message----- i have code written in VBA and at the end of the code i have this ChDir "E:\Joss Blaze\temp" ActiveWorkbook.SaveAs Filename:="E:\Joss Blaze\temp\temp.xls", FileFormat:= _ xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False _ , CreateBackup:=False MsgBox "Extraction Successful Proceed To Access", vbInformation, "Info." ActiveWorkbook.Close Application.Quit Excel.Application.Quit can anyone tell me how to overwrite the temp file automaticallywith out having to click yes while the messege "this files already exists do you want to overwrite...." thank you jordan . . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Overwriting cells | Excel Discussion (Misc queries) | |||
| Overwriting most of a workbook | Excel Discussion (Misc queries) | |||
| Overwriting #DIV/0 value using ISERROR | Excel Discussion (Misc queries) | |||
| Spreadsheets are overwriting each other | Excel Discussion (Misc queries) | |||
| Overwriting a file automatically using saveas in a macro | Excel Programming | |||
Linear Mode
