Compatibility Issue on VBA commands for Excel

S

Steve C.

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.
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trouble Installing Excel VBA Code Cleaner into Office 365 0
using Forms and VBA within Excel 3
Excel 2007 VBA - macro stops after autofilter command 6
Disable Commands using VBA Script in Excell 2007 1
Drawing in VBA - compatibility between Excel 2003 and 2007 6
VBA code won't run, even with Macro Security set to Enable All Macors 9
Excel 2000 compatibility 1
EOMONTH compatibility issue (workaround?) 1

Top