buddy, i'm mean the file i send u is excel 2003 (i.e .xls). but still you can use it and u can convert to .xlsx as well....
On Oct 22, 6:57 pm, simonl <simonlet...@googlemail.com> wrote: > 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- Hide quoted text - > > - Show quoted text - -- ---------------------------------------------------------------------------------- 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