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


.



.