Error in microsoft workbook invoke node

[P_innovative]

Hi All,

I have been working on reading a column of excel sheet using suggestions in LabVIEW forum that is using ActiveX from past two days. But could not proceed further due to error I am facing while using invoke node to open excel workbook and unable to figure out what problem is & what could be solution for same. Could someone help me on same. Attached my VI and screen shot of error i am facing.

Please let me know if you need any other information. Thanks in advance.

Thank and Regards,

Pragathi Devaraja

[Norbert_B]

Most important: NEVER implement infinite code execution without the option to stop it properly (for Windows targets that is)!

When working with interfaces, you should get used to close the interfaces "in opposite order". That means that you have to close the Excel Application as last item.

Norbert

[P_innovative]

Hi Norbert,

Thanks for your reply. I tried closing application refnum atlast but still facing same prob. i hope you meant same as solution. Attached code of same.

[Norbert_B]

You close the references at last, which is good, but still in the incorrect order. First close Sheets, then Workbook (you missed that), then Workbooks and Application as last.

Also please tell us which property/invoke node is creating the error exactly? You got two property nodes and two invoke nodes. Please use probes to identify.

Norbert

[P_innovative]

Hi,

Still facing same problem. I am facing problem in my workbooks invoke node.

 

[Norbert_B]

Is the Path valid?

Using the code on my machine works correctly....

Norbert

[P_innovative]

Yes path is valid(my document is in xlsx format). I tried in different paths and different files. but again same issue.

[Norbert_B]

Please check when setting the Excel visibility to true.

Norbert

[wade75 · Accepted solution]

Hello,

     Have you tried to open just an xls file instead of an xlsx file.  Which version of Excel do you have installed on your PC?

Regards,

     Wade

[P_innovative]

Hi Wade,

I am using 2010 version of excel. I tried in XLS format too which is again giving error. My LabVIEW version is 2014. Not sure what problem i am exactly facing when Norbert is able to run same program in his system without any error.