I am trying to change the value of a ComboBox within Excel from labview. I already have reference to the worksheet within labview, and it seems that I can find the control with a invoke node using OLEObjects and passing the control name I gave it in Excel to the index input. I use the variant that is given by OLEObjects and wire that to a variant to data VI. The type input is a control where I select the ActiveX control as either a ListBox or DropDown from the Microsoft Excel 11.0 Object Library or as a ComboBox from the Mircosoft Forms 2.0 Object Library Version 2.0. This all seems reasonable, but if I actually try to use a property node to view say the current text (or value) for the ComboBox or ListBox or DropDown, I get an error in Labview saying it doesn't like the reference. (The error code is either 3008 or some huge negative value depending on what I try)
One thing I can do is using an invoke node on the ListBox or DropDown type I can make the control visible or not visible in Excel by setting the visible property within Labview.
Why can't I see the current value of the ComboBox? Suffice it to say I can't change the ComboBox value either.
I even went as far as placing the ComboBox control in Excel using the same Microsoft Forms 2.0 Object Library as I am browsing to in Labview. The control works great in Excel, but I can't access it from Labview.
Help???
Thanks,
Craig
