ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel 2007 Macros compatibilty with earlier versions!! (https://www.excelbanter.com/excel-discussion-misc-queries/186638-excel-2007-macros-compatibilty-earlier-versions.html)

Raja

Excel 2007 Macros compatibilty with earlier versions!!
 
Are macros in Excel 2007 compatible with Excel 2003?

Pete_UK

Excel 2007 Macros compatibilty with earlier versions!!
 
Well, as long as you don't use any XL2007-specific features then you
should be okay.

So, don't use more than 256 columns or 65536 rows, don't use SUMIFS or
COUNTIFS, don't use conditional formatting with more than 3
conditions, don't use xlsx/xlsm filenames, don't use full-column
references in SUMPRODUCT or array formulae ... etc.

It might be safer to develop the macros in XL2003 and then use them in
XL2007.

Hope this helps.

Pete

On May 8, 12:50*pm, Raja wrote:
Are macros in Excel 2007 compatible with Excel 2003?




All times are GMT +1. The time now is 04:32 PM.

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