Suppressing the save as message box

rizwan · Mar 22nd, 2002, 12:04 PM

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 · Mar 22nd, 2002, 12:43 PM

This should work.



Application.DisplayAlerts = False

   oSheet.SaveAs "xyz.xls"

Application.DisplayAlerts = True

Mar 22nd, 2002, 12:43 PM	#2
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	This should work. Application.DisplayAlerts = False oSheet.SaveAs "xyz.xls" Application.DisplayAlerts = True __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 22nd, 2002, 12:04 PM	#1
rizwan New Member Join Date: Mar 2002 Posts: 1	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...