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 ?
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 ?