VBA - Writing in XL XP, executing in XL 97

[Paulo de Arruda Borelli]

Hi, is it possible to write VBA code using Excel 2002 (XP) and have it
executed in Excel 97? Is there a "converter" (or anything like that)?

Thank you,
Paulo Borelli.

 

[Tom Ogilvy]

The code is essentially the same, so no converter required (or available).
Where you have problems is if you record the code or if you write it and
include features added in versions later than xl97 (which would be typical
of recorded code). If you go into your code and remove these features, then
the code should run in xl97. Also, xl97 uses VBA5 and xl2000 and later use
VBA6. In VBA6, there were changes such as added functions like SPLIT, JOIN,
INVSTR and others. Excel5 doesn't recognize these either.

It is always best to write your code in the lowest verion of Excel where it
might have to run.

 

[Peter Huang]

Hi Paulo,

Did Tom's reply help you?
If you still have any concern on this issue, please feel free to post here.

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.