compatibility checker in excel 2007, turning it off

[Guest]

I need to save a folder full of excel files, but in .xls format. In 2007 it
always runs compatibility checker when saving in .xls. Is there a way to turn
this off in excel, turn it off with vba, or have code that would at least
check the ok box when asking if I still want to save in .xls format? Thanks

 

[Jim Rech]

I just did a quick test but it seems that stopping alerts block the
compatibility checker:

Application.DisplayAlerts = False
ActiveWorkbook.SaveAs "book1", xlWorkbookNormal ''XL97-03


--
Jim
|I need to save a folder full of excel files, but in .xls format. In 2007 it
| always runs compatibility checker when saving in .xls. Is there a way to
turn
| this off in excel, turn it off with vba, or have code that would at least
| check the ok box when asking if I still want to save in .xls format?
Thanks

 

[Guest]

Thank you Jim. It worked. You are a life saver.