overwriting a file

[Jordan Shoderu]

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

 

[Jordan Shoderu]

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]

Hi
try
application.displayevents=false
'your code
application.displayevents=true

 

[Keith Willshaw]

Hi
try
application.displayevents=false
'your code
application.displayevents=true

I think you mean Application.DisplayAlerts NOT displayevents

Keith

 

[Frank kabel]

Hi
as Keith already mentions I used the wrong name. Make this
application.displayalerts = ...