Report Generation Toolkit and Application Builder

[Mister_Rose]

I am going insane trying to work this out.

I am trying to build an EXE program using Application Builder. The program uses the Office Report Generation Toolkit.

I have tried including the dynamic VIs into the project, both from the Development machine and from the CD. I still have the same problem : the application does not start Excel. It is like the commands go into a black hole. There isn't even an error message.

I have attached my report VI for you to peruse. Any help is appreciated.

[Wayne.C]

Brian,

I'm guessing LV8.2  What version of Report Gen Toolkit?  Which dynamic files did you try to add in application builder?

[Mister_Rose]

Yes, Labview 8.2
Office Toolkit = 1.1.1

I have tried many combinations of what files are included, from just the top level VI, to every VI in the heirarchy tree (a major pain). I am now trying to rebuild the project from scratch and see if that does anything.

[Wayne.C]

Brian,

Make sure you are adding the following as a dynamic vi in the Application Builder.

_Excel Dynamic VIs.vi located in  vi.lib\addons\_office\_exclsub.llb

[Mister_Rose]

Yup, did that. I even added the Word module, too.

No luck.

The really bizarre thing is that I have another piece of software running on the same computer that uses the same test report module (with a different test data structure) and it works fine.

[Wayne.C]

Brian,

The New Report.vi has a terminal named Display Alerts.  By default it is FALSE.   If you set this to TRUE it will allow errors and warnings generated by Excel to be displayed.  You might give this a try and see if Excel is having a problem.

[Mister_Rose]

I tried setting the "Display Alerts" flag on NewReport.vi, but again nothing happened. I'm going to but some dialog boxes on the error lines and see if anything pops up.

[Mister_Rose]

When I plug into the Error cluster, I got an error about making sure all shared libraries are included.

I did have the Dynamic VIs discussed in other posts in the project. Do I need to include some DLLs or something?

[Wayne.C]

Brian,

I have never had to add anything more than the previously mentioned dynamic file.  Maybe you should create a simple vi that opens your template, edits one cell and exits.  Test that and see what happens.

What version of Excel?

[Mister_Rose]

Excel 2003