LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

PROPERTY NODE PROBLEM

Solved!
Go to solution

hello friends,

i have a big Problem. i want to open Excel on labviews, so i create 4 subIVs.

in one subIV i want to connect AUTOMATION MODE with a PROPERTY NODE called _Application.

If i do this, the property VISIBLE changes his colour from green to black and then i cant connect VISBILE to the boolean.

what can i do, sorry for my bad english.

0 Kudos
Message 1 of 8
(2,992 Views)

Hi yzqamar,

 

are you trying to do something like this?

check.png

Best regards,
GerdW


using LV2016/2019/2021 on Win10/11+cRIO, TestStand2016/2019
0 Kudos
Message 2 of 8
(2,986 Views)

Screenshot (1).pngScreenshot (2).png

0 Kudos
Message 3 of 8
(2,985 Views)

Yes Sir. exactly this is it, but when i connect Automation Mode to Property Node "Visible" gets black

0 Kudos
Message 4 of 8
(2,983 Views)

That's because you need an Automation Refnum control that you assigned the Excel Application class to, not an Automation Container. The container only can instantiate Active X control capable classes and the Excel.Application is not an Active X control class but an ActiveX automation class. 

 

The Excel ActiveX container class does not have a Visible property, Instead you make the container itself visible or invisible through a LabVIEW property for that object.

Rolf Kalbermatter
My Blog
0 Kudos
Message 5 of 8
(2,955 Views)

But GerdW also send the Code which is similar to my Code.

and How i do a refnum? sorry but its my first day on LabVIEW..

0 Kudos
Message 6 of 8
(2,931 Views)
Solution
Accepted by topic author yzqamar

Automation Refnum.png

After that right click on it and select Select ActiveX Class->Browse...

Rolf Kalbermatter
My Blog
0 Kudos
Message 7 of 8
(2,925 Views)

i thank you very much, you just safed my life

0 Kudos
Message 8 of 8
(2,920 Views)