excel does not close after closing all references and doing an application quit

[sumitrishi]

I m using LabVIEW 6.0.2

[Jim_Kring]

Is this a question, bug report, complaint, or are you asking others to corroborate your findings? You need to give a little bit more info about your problem, and what form of feedback you are looking for. Please take a look at the following:

http://www.catb.org/~esr/faqs/smart-questions.html

Specifically, the section on "Be precise and informative about your problem". I am not trying to give you a hard time. This is very useful reading for anyone who participates in volunteer support forums.

Regards,

-Jim

[Michael_Munroe]

I know this is not what you want to hear, but you need to close all references. Unless there is an error in the chain that is preventing the Quit command from executing, Excel should close properly.

Go back and look at all subvis make sure that every reference that does not leave the vi is closed in the vi. All references that are brought out must be closed somewhere else.

Otherwise, try to skip some of the Excel functions in your program and see if the problem disappears. Try to close the current Workbook before quitting to see if that happens correctly. You can also use the OpenG toolkit to try to close the application by window name.

Michael Munroe
www.abcdefirm.com

[sumitrishi]

I'm sorry that I posted my question in real haste and it ultimately ended making no sense . I think being a former NI R&D employee I should have been more careful . I apolgize for this error . Here is the question again .

Why is excel still visible in Task manager even if I close all the references to it and do an application quit in my VI?

[shoneill]

And don`t fotget, that any sub-objects called by ActiveX (Selection object or whatever) must also be closed (Even if you don`t wire it to anything), and in the reverse order to which they were opened.

This IS a nasty part to using Excel in this way, as every single object reference must be closed, and also in the correct order.

Shane