LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Close Excel

Hey It works as i want!!! Thanks A Lot. Thanks for being so calm and giving quick responses.
Kinnary.
0 Kudos
Message 11 of 12
(968 Views)
Dear Sir:

I have the same issue. As Joe mentioned before, "Everytime when an Excel activex automation is opened, it needs to be properly closed. If your vi opened excel but without either closing it or disposing its reference, it will hang in the memory (sometimes you may even notice when you double click on an excel file in explorer and you see only the title bar and toolbars but the working area is transparent. you will also see multiple excel references reside in the memory. The image showed a way to close the automation reference only and leave Excel open.

It seems NI updated the "Dispose Report.vi", however, I noticed the order of closing references are not what they should be. The correct order should be: shapes, _worksheet, Sheets, _workbook, _Application."

I already try to modified Dispose Report.vi, however, since I am using Labview7.1 and the content of my Dispose Report.vi in not same as in snap2.gif. How should I modify this vi to solve this problem?

Fred
0 Kudos
Message 12 of 12
(935 Views)