I'd like to know how to invoke compatibility checker via VBA, or
similar functionality.

I searched around the Object Browser and Microsoft Team Blog for an
answer, but didn't find anything at this point (http://blogs.msdn.com/
excel/default.aspx).

I would like to do is save all Workbooks in my scripts as 95-2003
format (.SaveAs FileFormat = xlExcel8) whenever possible. So I need a
way to programmatically determine if the Workbook can be properly
saved in this format. I'd basically like to invoke the Compatibility
Checker via VBA. Or, alternatively, are there ways to conditionally
check the compatibility of the Workbook prior to saving?

This is all assuming a newly created workbook which has not been saved
yet. I would rather not have to create my own checks for every
possible 2K7 difference (e.g. data in rows > 64k, etc...)

TIA

On Jul 18, 4:15 pm, keeena <kee...@hotmail.com> wrote:
> I'd like to know how to invoke compatibility checker via VBA, or
> similar functionality.
>
> I searched around the Object Browser and Microsoft Team Blog for an
> answer, but didn't find anything at this point (http://blogs.msdn.com/
> excel/default.aspx).
>
> I would like to do is save all Workbooks in my scripts as 95-2003
> format (.SaveAs FileFormat = xlExcel8) whenever possible. So I need a
> way to programmatically determine if the Workbook can be properly
> saved in this format. I'd basically like to invoke the Compatibility
> Checker via VBA. Or, alternatively, are there ways to conditionally
> check the compatibility of the Workbook prior to saving?
>
> This is all assuming a newly created workbook which has not been saved
> yet. I would rather not have to create my own checks for every
> possible 2K7 difference (e.g. data in rows > 64k, etc...)
>
> TIA

To clarify, I am using Excel 2007.