Report generation using Excel

[Bijan Najafi]

I created a VI for making a report in Excel. It works correctly, however when I built an executable files, it is unable to do the processing and announce ‘error 7 open VI reference in Excel’! I was wondering if anybody can guide me that how I can fix this error. Many thanks

[Johnner]

Bijan,

You need to add a dynamic VI to your list of Source Files in the Build Application window. The one you need is called "_Excel Dynamic VIs", and it can be found at \vi.lib\addons\_office\_exclsub.llb . Doing this ensures that the executable can find the appropriate code when it is asked to dynamically load some Excel-related VIs at execution-time.

--John

[Bijan Najafi]

Thanks so much! I tried it and now it works correctly.

[222]

Currently I'm using LabView 8.0 and having the same problem too. But how could I add the dynamic vis into the Dynamic VIs and Support Files as I couldn't view any files from My Computer (under source files when building exe windows) to locate for the required lbb files. There is only one vi in the window. Can anybody help me on this? Thanks

[Darren]

Hello,

I think that if you add the Excel/Word dynamic VIs to your project, you will see them in the VI list when building your EXE, which would allow you to add them to your application as dynamic VIs.  I'm guessing you currently don't have the Excel/Word dynamic VIs added into your project yet.

Good luck,
-D

[222]

Thanks for your suggestion. I managed to get it done...