So do you suggest I un-install and re-install Office? On 22 Oct, 15:20, Ashish Jain <ashishj...@openexcel.com> wrote: > 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.comhttp://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
