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

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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

That did it. Thanks!

- Mark

On Sun, 15 Jul 2007 14:28:37 +0530, "shah shailesh" <(E-Mail Removed)> wrote:

>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" <(E-Mail Removed)> wrote in message
>news:(E-Mail Removed)...
>> 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
>