LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Labview Excel Container can't close Exceel

I have an application that uses a container. I chose as the active X object an Excel Shpeadsheet, but I notice that the container reference is to an Excel Workbook, OK fine. I use the properties and methods to select sheets in the workbook and to read and write data, no problems. The problem comes when I go to close down. I have tried closing all references, but when I finish Excel is still running long after I close labview. I have plenty of experience with straight out active x and have performed these same actions on Excel without the container. What is different about the container. It seems to automatically start Excel, but gives no way of closing it. I even tried calling the parent of the workbook(W
orkbooks), the parent of workbooks(Excel application) and closing down and deleting their references in reverse order of their creation, still Excel runs. Anyone out there solve this problem?
0 Kudos
Message 1 of 3
(2,959 Views)
Hello,
I've run into the same, if you have opened any sub-references to sheets, books etc they all need to be closed. What you have is a surviving reference floating about.
I wrote a container that kept all these references in shift registers and I needed to ensure that every new instance was closed after it was finished with. By the way it took a while to chase them all down.
If it is excel 97 and all you want to do is put data in tables and copy graphs I can forward you a copy of our component
Steve Watts (ssdc)

Steve


Opportunity to learn from experienced developers / entrepeneurs (Fab,Joerg and Brian amongst them):
DSH Pragmatic Software Development Workshop


Random Ramblings Index
My Profile

0 Kudos
Message 2 of 3
(2,959 Views)
Steve: Thank you for the answer, I thought I had found all references, but I guess I had better look some more, if you are able to close just fine. I would be interested in seeing the code that you used even though I am using Win 2000 and Office 2000. I bet I can quickley find my error. Thanks Again.

bbushey@mail.snet.net
0 Kudos
Message 3 of 3
(2,959 Views)