VBA code runs in Excel 2003, fails in 2000

[Andrew]

Hello,
I have written some VBA code for an Excel 2003 spreadsheet. It
works fine on all 2003 systems but it doesn't run in Excel 2000. Is
there any way of compiling the code in Excel 2003 so that it will run
in Excel 2000?

thanks,
Andrew

 

[Chip Pearson]

Most likely, you have options or methods that exist in 2003 but not in 2000.
There is no way to compile code in 2003 with the assurance that it will work
in 2000. Essentially, you need to know what is new in 2003 and not use
those features. Sadly, no such cross reference exists.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)