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