Avoid Using New Features

If your application must work with Excel 2003 and earlier versions, you need to avoid any features that were added after the earliest Excel version that you will support. Another alternative is to incorporate the new features selectively. In other words, your code can determine which version of Excel is being used, and then take advantage of the new features or not.

VBA programmers must be careful not to use any objects, properties, or methods that aren't available in earlier versions. In general, the safest approach is to develop your application with the lowest common denominator. For compatibility with Excel 97 and later, you should use Excel 97 for development; then test thoroughly by using the other versions.

0 0

Post a comment