LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

Error in microsoft workbook invoke node

Solved!
Go to solution

This may sound like a stupid question but do you have the file open already when you try to run this code?  You can right click on the node and select Ignore Errors inside the Node but I'm not sure if it will still give you a worksheets reference ID out.

0 Kudos
Message 11 of 17
(705 Views)

1st thing - My excel sheet is not open.

2nd thing - I am getting error in invoke node(That is workbook invoe node) and ignoring error in invoke node is not possible. We can ignore only in property node.

0 Kudos
Message 12 of 17
(701 Views)

From Microsoft:

Error 2146827284 Microsoft Excel cannot open or save any more documents because there is not enough available memory or disk space

It could be because Youre running this in a loop as fast as the CPU will allow, and youre in fact not closing your workbook, but only closing the reference. Build in a Close workbook invoke, and it should be fine. (I hope)

Don't forget to rate a good Answer....
---------------------------------------------------------
Here should be some cool signature

But there's NOT

LabVIEW 2012-2017
---------------------------------------------------------
0 Kudos
Message 13 of 17
(689 Views)
Solution
Accepted by topic author P_innovative
10-25-2016 06:36 AM

This error can have different sources but in your case I would guess this is a local ID issue. Is your machine locale set to something else than US English? Have a look at this link.

 

Also, Sheets Item Index is NOT zero base, this will throw another error. Index of the first sheet of a workbook is 1.

 

Ben64

 

 

--------------------------------------------------
The best way to say thanks is to give kudos!
0 Kudos
Message 14 of 17
(682 Views)

I tried with different solution mentioned by you all, now it is fixed. Below is my solution. Thanks to all for your help and patience in providing solutions.

 

Solutions:

1. Excel sheet should be in xls format. I changed my xlsx format to xls format.

2. Changed index of sheet to 1 from 0.

 

But i need one more small clarification. I there any way of using xlsx format instead of xls format?

0 Kudos
Message 15 of 17
(678 Views)

I would make sure there are no previous instances of excel open from when you were closing your references in the wrong order.  You can check by opening task manager, then looking through the processes and aborting all the excel references and trying your code again.  I've gotten errors before when there have been previous references still open in task manager when dealing with Excel using active X.  Not saying this is the root cause of your error but its a simple check.

0 Kudos
Message 16 of 17
(676 Views)

I generated an xlsx file and opened it using active x with no errors.  But this was a fresh blank spreadsheet.  There maybe something in your spreadsheet causing this error you are seeing, or your Object Library your have selected for your open active x application is maybe incorrect.  Which Library are you using.  I believe Excel 2010 using version 14.

0 Kudos
Message 17 of 17
(668 Views)