Excel 2000 /2002 library problems

[mika]

Hi,

I modeified an excel spreadsheet in excel 2002 and now am
trying to work with it in 2000. I have vba code in it.
However when i try to open it in excel 2000 on a
different computer i get compile error: project or
library not found. I was looking at the differences in
the library references and i believe that excel 2000 only
had the object 9.0 libraries while excel 2002 was using
the obejct 10.0 libraries. What can i do to make my code
work in excel 2000?? Thanks so much.

Mika

 

[Nigel]

Make a reference to the object 9.0 libraries and try again you might find it
will work depending on what features are being used. I had similar problems
using the outlook 10.0 library after installing in an Excel97 environment.
I made reference to outlook 8.0 and everything worked OK.

Otherwise I guess you'll have to modify the code!

Cheers
Nigel

 

[mika]

Make reference to the object 9.0 libraries where, in
Excel 2002? I couldn't find it in the
references...please clarify!

Thanks
mika

 

[Nigel]

If you wish to run the code in Excel 2000 then you need to select the
version 9.0 libary, there won't be a version 10.0 that was available in
Excel 2002.

So on your Excel 2000 machine, open the workbook, open VBE and select the
same object library v9.0, save the workbook and try to run the application.
If this did not utilise features only in v10.0 then you should be OK, esle
you need to change things.

You should be able to run the workbook back in your Excel 2002 environment
without change.

Cheers
Nigel