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

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
"Need Help Fast!" <(E-Mail Removed)> wrote in message
news:91C904C3-1662-4011-AB5D-(E-Mail Removed)...
|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

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

"Jim Rech" wrote:

> 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
> "Need Help Fast!" <(E-Mail Removed)> wrote in message
> news:91C904C3-1662-4011-AB5D-(E-Mail Removed)...
> |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
>
>
>