08-24-2008 09:43 PM
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
08-25-2008 12:00 AM
08-25-2008 01:36 AM
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
08-25-2008 01:43 AM
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
08-25-2008 02:47 AM
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
08-25-2008 03:23 AM
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