VBA - Macro backward compatibility from excel 2002 to excel 2000

[Frank Krogh]

I have read that in the excel help that "the Microsoft Excel 2002 file
format does not differ from the Microsoft Excel 2000 and Excel 97 file
formats, but it does differ from earlier versions". Unfortunately I have
received feedback that it doesn't seems to be a macro backward compatibility
from Excel 2002 to Excel 2000.

I have unsuccessfully tried to save an Excel 2002 workbook as a Excel
2002/excel 97 compatible format, and there is no Excel 2000 option in the
"Save as type" rolldown menu.


Is there any way to solve this problem or workaround it?


Thanks for suggestions.


Frank Krogh

 

[Frank Kabel]

Hi
always try to develop in the lowest version. There's no option to
convert macros to a lower version.

 

[Charles Williams]

Hi Frank,

The file format is compatible from 2002 to 97, but if you use features that
are Excel 200 or excel 2002 only they wont work in 97.

VBA code is lcompatible except if you use Excel 2002/2000-only object model
features or use VBA6 only features.
(Excel 97 is VBA5)
You may need to change the references (Tools References)

If all else fails then export the modules and forms from Excel 2002 and
import them into Excel 97.


regards
Charles
______________________
Decision Models
FastExcel Version 2 now available.
www.DecisionModels.com/FxlV2WhatsNew.htm

 

[Howard Kaikow]

If you develop a macro to be used over multiple versions, the macro code has
to either take care to not use VBA not supported in earlier versions or to
appropriately design the code so code for later versions is not in the same
modules as code for earlier versions. In the latter case, you then choose
which code to execute at run time.