2007: CheckCompatibility not honored

[Mark Olbert]

If I set CheckCompatibility to false on a workbook in a macro, and then do a SaveAs to downrev it to, say, Excel 2003 format, the
compatibility checker still runs...which is annoying.

How do I get Excel to NOT run the compatibility checker when saving files to earlier version from within a macro?

- Mark

 

[shah shailesh]

Try this,

Set DisplayAlerts Property to false before your code for saving & set to
true afterwards


Application.DisplayAlerts = False
'codes for saving the workbook
Application.DisplayAlerts = True


Regards,
Shailesh Shah
http://in.geocities.com/shahshaileshs/
(Excel Add-ins Page)
If You Can't Excel with Talent, Triumph with Effort.

 

[Mark Olbert]

That did it. Thanks!

- Mark

Try this,

Set DisplayAlerts Property to false before your code for saving & set to
true afterwards


Application.DisplayAlerts = False
'codes for saving the workbook
Application.DisplayAlerts = True


Regards,
Shailesh Shah
http://in.geocities.com/shahshaileshs/
(Excel Add-ins Page)
If You Can't Excel with Talent, Triumph with Effort.