$$Excel-Macros$$ Re: Annoying popup for with Cancel button when opening workbooks

ww.excelitems.comhttp://www.openexcel.com > > On Oct 22, 6:05 pm, simonl wrote: > > > > > We recently upgraded to Excel 2007 from Excel 2000. I have a VB6 app > > that uses Automation to start Excel, loop thru a lot of workbooks > > opening each of them and

$$Excel-Macros$$ Annoying popup for with Cancel button when opening workbooks

We recently upgraded to Excel 2007 from Excel 2000. I have a VB6 app that uses Automation to start Excel, loop thru a lot of workbooks opening each of them and then check various things in the workbook. It worked fine in Excel 2000 and uses Application.Visible = False and Application.DisplayAlerts