Excel Colour properties modified via LabVIEW

[drewsali]

smercurio,

Thanks for the code. Unfortunately my problem persists. I've attached a screen shot of the VI you sent me as I've opened it, untouched and broken! There must be a setting or a library in LabVIEW that I don't have. Not sure where to look next. 😞

Andrew

[smercurio_fc]

What version of Excel are you running? What you would see would be dictated by that, and nothing to do with LabVIEW.

What happens if you click on the "Item" element? You should get a popup list of methods that can be selected. What happens when you re-select "Item"?

[drewsali]

I'm running Excel 2007. Yes, the menu comes up when I click "item", but no change when I reselect it.

[smercurio_fc]

I figured you were probably running 2007. Microsoft often changes the datatypes on their ActiveX classes just because they like to screw around with people's code. What you will need to do is to use the Variant To Data function to convert the variant to the appropriate ActiveX class. In this case it would be the Excel.FormatCondition. You should then be able to connect the output of the Variant To Data to the property node. See attached.

[drewsali]

The appropriate ActiveX class. That's the trick! Thank you for your efforts

Andrew

[drewsali]

I just posted a related question in a new thread.

Andrew

[Andreai]

hello at all,

someone can convert the example attached on top in 8.5 LV relase ?

 tnks

[RavensFan]

LV 8.5