Program using ActiveX does not work on Excel 2002, but does work on Excell 2000.

[mitchell cao]

I wrote a Labwindows/CVI program that communicates with Excel through ActiveX. I ran it on one computer, running Excel 2002 and it works fine, without any problems. But when trying to run it on another computer, runnning Excel 2000, I get a illegal operation error. I tried it on two computers, both running Excel 2000 and on both it crashed. Is there some incompatibility between the Excel 10.0 Object Library that I used in my Labwindows/CVI 6.0 program and Excel 2000? Or do I need to install something else on the other computers to make my program work on them?

I have included the error message from the illegal operation prompt in the file included.

[bilalD]

Hello

It might be a backwards compatibility issue. Excel 2000 ( which provides the Excel 9.0 object library) will probably not play very well with the Excel 10.0 (Excel XP) library. On the other hand, the 9.0 library does work with both Excel XP and 2000. You might want to try developing your program with the 93.0 library instead.

I hope this helps

Bilal Durrani
NI