Report Generation Exe Error

[_Bryan]

Hello,

 I am using LV 8.6.1 with the 1.13 report generation toolkit and I am having problems getting my built exe to work.  I am trying to open an excel template and populate it with new data.  I have broke the vi down to just opening excel - opening the template and then fill in some data.  But at this point excel does not open at all.  And naturally everything works fine in the development environment.

Error Code: -2147352573

Member not found in NI_ReportgenerationToolkit.lvlib:

Excel_open_workbook.vi

NI_Excel.lvclass: new reportsubvi.vi

I read a few help pages that said to add \vi.lib\utility\NIreport.llb and LVclass directories to the project folder and add them to the always include section of the build.  But no luck so far.

Side question:  The machine I want to use this on has 8.6.1 Full which does not have the extra excel functions that my developer has.  Is there a way to install the DEV report generation toolkit in the full version?  Then I would not need to build an exe.

UPDATE:  I just tried the exe on a different machine that has a developer suite installed and it worked fine.  So I guess I need to find out what else I need to add to the build to make it work.

Message Edited by _Bryan on 06-16-2010 11:58 AM

[TCPlomp · Accepted solution]

Do the Excel versions are the same?

Microsfoft has been improving the ActiveX interface for every version in such a way that an old instance could not connect.

Ton

[_Bryan]

I just got back from checking the version of Excel.  It seems that machine has 2000 on it, so I will try to get it updated and see what happens.  Looks like I need excel 2003.

[TCPlomp]

No, in your build settings you should include some specific VI for Excel 2000.

Ton

[_Bryan]

How can I modify the existing vi's to work with 2000?

This is an existing program that needs to be run on an additional machine for a short term test.  So I was thinking it would be easier to have our computer department upgrade excel and word.  Otherwise I will have to dig through 30-50 vi's to check for report generation vi's.

But if you have an easier way I would be willing to try it.

[TCPlomp]

There should be some info on this in the KB.

But first you should make sure that your version of the report generation toolkit actually supports excel 2000 (which is 10 years old)

That should be in the release notes of the toolkit

Ton

[_Bryan]

The readme says 2003 and 2007 for ver 1.1.3.  That is why I was not sure how to add in vi's for 2000 in the current setup.  So the upgrade is looking good again......

[TCPlomp]

yes it is. Good luck.

Ton

[_Bryan]

Thanks

[_Bryan]

Updating excel and word worked wonders.......  I knew the machine was old, but I did not realize it was that old.....