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

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


.

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


.

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

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


.



.