replace the file using save as method

[nisha]

while using objWkb.Saveas method it gives me a pop up if the file already exists asking for replacing the file. How do i default it to yes and replace the file without prompting any message to the user??

 

[DCrake]

You can turn the alerts off in the same way you do in Access. Not sure of the exact syntax though.
Set Alerts = False