Compatibility Issue on VBA commands for Excel
 

Hi all,
I'm using Excel 2002 and need to develop Excel
applications for my department. However, due to some of my
peers are still using Excel 2000, they are very often
encounter errors when running my applications. I wonder if
there is any table showing the equivalent VBA commands for
various Excel versions so that I can detect user's Excel
version at Workbook_Open event and use appropriate VBA
commands accordingly. Any expertised advice help me tackle
the issue is highly appreciated.

Compatibility Issue on VBA commands for Excel
 

Why don't you use Excel 2000 to build your applications? AS Excel 2002 is
upward compatible, you will have fewer, if any at all, errors.

"Steve C." wrote:

Hi all,
I'm using Excel 2002 and need to develop Excel
applications for my department. However, due to some of my
peers are still using Excel 2000, they are very often
encounter errors when running my applications. I wonder if
there is any table showing the equivalent VBA commands for
various Excel versions so that I can detect user's Excel
version at Workbook_Open event and use appropriate VBA
commands accordingly. Any expertised advice help me tackle
the issue is highly appreciated.