Suppressing the save as message box

[rizwan]

Hi:

I am using an Excel object to save data from a VB Application. The application has to be run unattended coz it collects the data from the database and save it to Excel file every midnight. The problem is it gives a message box "A file names xyz.xls already exists in this location. Do you want to replace it?"
which i do not want coz it is supposed to be unattended. Following line of code I am using

oSheet.Saveas "xyz.xls"

Is there a way out ??? thanks in advace...

 

[Mark O'Brien]

This should work.


<pre>
Application.DisplayAlerts = False
oSheet.SaveAs "xyz.xls"
Application.DisplayAlerts = True</pre>