I have a customer using some code I developed and they just switched to Office 2007 and Excel 2007. Seems that now my program is prone to "Compatability Checks" - see this Microsoft blog link on the error which is now received

http://blogs.msdn.com/excel/archive/...11/694891.aspx

This worked beautifully with eearlier versions of Excel and now I have issues....

I understand that when this compatability dialog comes up I can have my customer click the check box the click Continue - basically turn off Compatibility Mode during the ActiveWorkbook.save. But this is a nice workaround... I'd rather not.

What I'd rather do is programatically turn off Compatibility Checking when my customer is using Excel 2007 to run my program.

So first - determine if Excel 2007 is running.
Second - turn off Compatibility Checking.

Any hints on if this is possible and how?

Thanks,