LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Error in microsoft workbook invoke node

Solved!
Go to solution
Highlighted

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. Error.jpg

 

Thank and Regards,

Pragathi Devaraja

0 Kudos
Message 1 of 17
(1,368 Views)

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

Norbert
----------------------------------------------------------------------------------------------------
CEO: What exactly is stopping us from doing this?
Expert: Geometry
Marketing Manager: Just ignore it.
0 Kudos
Message 2 of 17
(1,367 Views)

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. Aufnahme3.jpg

0 Kudos
Message 3 of 17
(1,358 Views)

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

Norbert
----------------------------------------------------------------------------------------------------
CEO: What exactly is stopping us from doing this?
Expert: Geometry
Marketing Manager: Just ignore it.
0 Kudos
Message 4 of 17
(1,353 Views)

Hi,

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

 Aufnahme4.jpg

0 Kudos
Message 5 of 17
(1,348 Views)

Is the Path valid?

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

 

Norbert

Norbert
----------------------------------------------------------------------------------------------------
CEO: What exactly is stopping us from doing this?
Expert: Geometry
Marketing Manager: Just ignore it.
0 Kudos
Message 6 of 17
(1,321 Views)

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

0 Kudos
Message 7 of 17
(1,315 Views)

Please check when setting the Excel visibility to true.

 

Norbert

Norbert
----------------------------------------------------------------------------------------------------
CEO: What exactly is stopping us from doing this?
Expert: Geometry
Marketing Manager: Just ignore it.
0 Kudos
Message 8 of 17
(1,310 Views)
Solution
Accepted by topic author P_innovative
10-25-2016 06:37 AM

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

0 Kudos
Message 9 of 17
(1,304 Views)

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.

0 Kudos
Message 10 of 17
(1,301 Views)