Macro compatibility issue between XP & 2000

  • Thread starter Thread starter Jojo Anacay
  • Start date Start date
J

Jojo Anacay

A macro was developed in excel XP, no error occurred
during the testing, but when the macro was tested in Excel
2000 2 errors occurred. Is there a compatibility problem
between Excel XP and Excel 2000, particularly in macros?

Error encountered :
1. Wrong Number of Argument or invalid property assignment
In Excel 2000, by pressing Ctrl-T (Insert of rows)this
message appear by continously append a row.

2. Compile Error in hidden module: this workbook.
In Excel 2000, pressing Ctrl-Y (Copy) no copy taken at
all.

Thank you very much.
- jojo
 
Microsoft goes to great lengths (and is usually successful) to insure that
old code runs in new versions of Excel. But the reverse can never be true
else they could not add enhancements to existing functions, objects,
methods, etc, or add new functions, etc.

If you can narrow down the problem to specific lines of code you can either
check VBA Help to see what has changed in newer versions or post them here.

If you are developing applications to run in several versions of Excel you
should do your developing in the oldest version so you do not inadvertently
use features that are not available in older versions.
 
Back
Top