LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Problem for Report Generation Toolkit for excel 2000

Hi all,

 

Now I am Developing my program with Report Generation Toolkit 1.1.0 and Labview 7.1.

In my computer I am using Excel XP, and there is not any problem. But when I build to

a exe file, and use in a computer with Excel 2000, it didn't work.

And I try to check the source file in this computer, I found that there any some connection

error. And this is caused by the active X class. As I know Excel 2000 is using Microsoft Excel

Object Library 9.0, but i cannot find it in the list of active x. So it is using Microsoft Excel Object

Library with a very old verison. So in the property node there are missing functions, such as the

UsedRange in _Worksheet in the Excel_Get_Range.vi. However, In VBA, I can find the 9.0 Library.

Is it the problem of 9.0 library? How can I solve the problem? How can I upgrade the library to 10.0?

Thanks.

 

Regard,

Ryan

0 Kudos
Message 1 of 6
(2,824 Views)

Hi Ryan,

see this link please.

 

Hope it helps.
Mike

Message 2 of 6
(2,811 Views)

Hi Mike,

 

Thank you for your help.

But my problem is no matter I build to exe or run in VI, it also has error.

And I already take the action of the link.

 

Regard,

Ryan

0 Kudos
Message 3 of 6
(2,801 Views)

Hi Ryan,

did you install the newer Excel version after LabVIEW and the Report Generation Toolkit? Do you need the possibility to run your program with both Excel versions?

Mike

Message 4 of 6
(2,797 Views)

Hi Mike,

 

Since my program is for all the staff in office, everyone may use it.

I cannot call the whole office to upgrade the excel to XP.

And I think Report Generation Toolkit is alway support Excel 2000,

since the old version of it is not support for Excel XP.

 

Regard,

Ryan

0 Kudos
Message 5 of 6
(2,791 Views)

Hi Ryan,

i think you should reinstall the report generation toolkit. If you want to support both excel version, then you have to check which version is currently running on the machine and select the correct activeX function. You can use dynamic calls to choose which you need.

 

Hope it helps.

Mike

Message 6 of 6
(2,782 Views)