ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   COMPATIBILITY CHECKER ON 2007 (https://www.excelbanter.com/excel-discussion-misc-queries/247722-compatibility-checker-2007-a.html)

BILLROT

COMPATIBILITY CHECKER ON 2007
 
I have designed a model in Excel 2007 to automatically e-mail excel files
(2003) to various e-mail addresses. As the model processes the compatibility
checker comes up for each loop of the macro. Is there a way to over-ride
this action??

Ron de Bruin

COMPATIBILITY CHECKER ON 2007
 
Hi BILLROT

You can use this in the code

ActiveWorkbook.CheckCompatibility = False



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"BILLROT" wrote in message ...
I have designed a model in Excel 2007 to automatically e-mail excel files
(2003) to various e-mail addresses. As the model processes the compatibility
checker comes up for each loop of the macro. Is there a way to over-ride
this action??



All times are GMT +1. The time now is 06:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com