LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Set excel cell color and border broken, can't build application

Hello,

I am trying to build an application in Labview 2011 and I am getting an error because one of the vi's in the report generation toolkit is broken. When I try to build my application, I get the following error: 

An error occurred while saving the following file:

C:\Program Files (x86)\National Instruments\LabVIEW 2011\vi.lib\addons\_office\excel.llb\Excel Set Cell Color and Border.vi

 

When I check the VI it is broken and returns an error of :

Invoke Node: Contains unwired or bad terminal

 

I've tried reinstalling the report generation toolkit and that did not solve the problem, does anyone have any ideas on how to fix this?

 

Thanks,

Steve

0 Kudos
Message 1 of 5
(5,860 Views)

Open up the subVI that is listed and see what the error is.

 

Microsoft changes their ActiveX model between the various versions of Office.  Sometimes they add or delete properties, or even rename them.  If the Excel library was created and saved when it was linked to a particular version of Excel such as 2003, and you have a different version of Excel installed on your PC such as 2007, then some of the ActiveX property nodes or invoke nodes may be broken.

 

You need to track down the errors and fix them so that they'll work on your PC with your installed version of Excel.

0 Kudos
Message 3 of 5
(5,853 Views)

@smurcurio_fc: Well I searched but that didn't come up, anyway thanks for posting that I was able to fix it after reading through that thread. 

0 Kudos
Message 4 of 5
(5,848 Views)

When I changed my PC and a new Excel version was installed, in my case, this error was solved "re-linking" the invoke node.

 

Vicen

0 Kudos
Message 5 of 5
(4,187 Views)