add Report Generation toolkit for Microsoft Office in exe

[ltok]

Hi

I am having a problem. I am using LabVIEW 8.20, Report Generation Toolkit for Microsoft Office 1.1.2 and Microsoft Excel 2003. My OS is Windows XP (SP )

I want to build the vi attached below into an exe. The vis that I used are from addons>>_office>>excel.llb. I follow the suggestion found in the link below and add in all the files in excel.llb into my project so that it can be added into the executable as dynamic vis. However, some vis in excel.llb cannot be added into my project. After I have add all vis that can be added into the project, I build an application (exe) with the vi below as the Main vi and all other added vis (from excel.llb) as dynamic vis. After that, I build and run this exe on the same PC. I am unable to run it.

This vi will save datas when I click on the stop button. After I click on the stop button, a window will pop-up and prompt me to select which directory to save the vi. When I run the exe, I type in test.xls (for example) but the file saved is a picture and not an excel file. If I just run the vi instead of the exe, Excel will open and datas and graph will be displayed in Excel.

May I know where did I done wrong??

How do I use the Report Generation Toolkit in an executable with Microsoft Excel?

http://digital.ni.com/public.nsf/websearch/C38CE3F30542D65B86256F0E00740DD8?OpenDocument

Thank you & Regards

Lee

[Wayne.C]

You only need to add one dynamic vi from the Excel library.  Look at page 9 of the Report Generation Toolkit manual for the specifics.  http://www.ni.com/pdf/manuals/323805a.pdf

[ltok]

Hi centerbolt,

Thank you for your reply. I have tried adding in just that dynamic vi found in Excel Library and my main vi but it still cannot work. Is there anything that I need to look out as well?? [View attached picture.]

Thank you & Regards

Lee

[Wayne.C]

Lee,

It looks like you are writing the excel file and the .bmp to the same filename.  Because you did not wire up the error cluster for the property node that is writing the .bmp file, you have a race condition to see which file gets written first.  That is why it acts different when you run the .exe.  You need to use two different filenames for these two files.