opening excel file with active x closes already open excel app

[id]

I am experiencing an odd thing in that Excel 2007 when open with a spreadsheet file open in it ...it gets clobbered when I run my labview app that simply opens an excel file and reads it in.  The existing excel app gets completely closed.  Any body know why this can occur?

[Whit-E_Wall-E]

Hello,

It depends on how you close the references at the end of your VI.  For instance in this example it closes the Worksheet, then the Workbook, and then the Excel Application at the end of the VI.  In this specific example it is expected to close the Excel Application by the last Close Reference function.

[id]

thanks but doesnt the application quit method actually close down excel? If you were to close the ref to the application without invoking the quit method, would ther be a problem?

[Whit-E_Wall-E]

Yes, the Quit Method is the specific function that closes down the Excel program.  I do not see any issues with getting rid of the Quit Method, but leaving the Close Application as that will close the necessary reference in LabVIEW.

[id]

I discovered a problem today that the closing of excel down only occurs when running the exe and not the IDE version.  Here is my code.

[Whit-E_Wall-E]

I ran the program as a VI and as an EXE, however on my system neither way caused Excel to close.  What is currently open in Excel when you run the VI and it closes Excel?

[id]

Any excel file.  I have Excel 2010 on Win7.  I have also seen this on other machines with hte same load at my work with the exe. .

[Whit-E_Wall-E]

In your application if you disable your last "Close Reference.vi" does Excel still close in the executable?