How to conditionally determine Workbook save compatibility in VBA?
 

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

How to conditionally determine Workbook save compatibility in VBA?
 

On Jul 18, 4:15 pm, keeena 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.