Hi Simon, Application.DisplayAlerts = False still works ! It works in all versions of excels i.e.2003, 2007 & 2010.
Take Care of these points: 1. Use new event macro - Private Sub Workbook_Open() 2. Enable the Macros(Right below Formula Bar) whenever you open the workbook. Regards Ashish Jain McKinsey India Knowledge Center (Microsoft Certified Application Specialist) (Microsoft Certified Professional) http://www.excelitems.com http://www.openexcel.com On Oct 22, 6:05 pm, simonl <simonlet...@googlemail.com> 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 then check various things in the workbook. It > worked fine in Excel 2000 and uses Application.Visible = False and > Application.DisplayAlerts = False. I now find that Excel 2007 pops up > a "progress bar" form with a Cancel button when opening some of the > files (maybe where the size of the file exceeds some value). The files > are in the "old" XLS format. Does anyone know of how to stop this form > from appearing? > > Have tried googling but could only find the DisplayAlerts = False > which I am already using. > > Thanks > > Simon -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
