Dispose Report closes all Excel spreadsheets

[henry]

With Report generation toolkit, I am creating an excel spreadsheet. I create a "New Report", do stuff and "Dispose Report". When I "Dispose Report", it closes ALL excel spreadsheets that are open, including ones that are not part of the LabVIEW application, with no warning. Is this correct? How do I avoid this annoying behavior?

[Zvezdana S.]

Henry,
This is the expected behavior. The Dispose Report VI calls Excel_Quit.vi. This subVI calls _Application.Quit Excel method. You can modify this subVI to not call this method, or to call it if you press a boolean button.
Excel_Quit.vi is located in \vi.lib\addons\_office\exclsub.llb

Zvezdana S.
National Instruments

[Kennon_Cotton]

Henry,

As Zvezdana mentioned the 1.0 version of the Report Generation Toolkit does work this way. Since that behavior isn't very desirable it has been changed in the 1.1 version of the toolkit which released in March. The new version only closes the report for the particular reference being disposed. You also have the option of not closing the report when you dispose the reference.

Kennon