PDA

View Full Version : Skip Confirmation Prompt while saving Excel file as htm through VBA code



sri_sssitc
02-27-2009, 02:35 PM
I am saving a set of excel files to html by looping through the folder in VBA code using the SaveAs method of the Workbook object.

While attempting to save, VBA throws up a confirmation prompt like "You are saving blah blah file to html.... Are you sure you want to blah blah.... ". If I say yes, it continues to save. The problem is when the loop runs, I have to say yes for each file.

The situation occurs on Excel 2003 (Windows XP SP2). It does not occur on Excel 2000 (on Windows 2000 Professional) where the solution was developed.

Question: How do I suppress the confirmation prompt that Excel 2003 throws up ?

MaximS
02-27-2009, 02:41 PM
use that to turn it off

Application.DisplayAlerts = False


and that to turn it on again

Application.DisplayAlerts = True