Macro Compatibility

[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?

 

[Jojo Anacay]

1. wrong no. of arguments or invalid property assignment
2. compile error in hidden module: this workbook

Thanks.

-----Original Message-----
What were the errors?

 

[Myrna Larson]

So what does the code in ThisWorkbook look like? Have you tried to get into VBA and compile it
so you can see where the error is.

1. wrong no. of arguments or invalid property assignment
2. compile error in hidden module: this workbook

Thanks.