Excel form captions + list selection

Hi,
I'm trying to build some MS Office test automation functions at work in VC++. Accessing all the Excel form properties through this OLE thing (don't know what it's called exactly). Works fine so far.

But there's one thing I'm missing at all: How can I get the caption of an Excel-proprietary form control? Say a commandbutton or a checkbox.

I have the VBA name, location (in something like pixels * anything), whether the checkbox is checked (funny thing that, 'value' is always in {-4146, 1, 2}...) aso. But I need the control's caption to find it from the user's description. It doesn't even seem to be mentioned in the Excel/VBA help, and that's where I look first for a description of the otherwise undocumented C++ wrapper classes.

Ehm, no, I'm not talking about the ActiveX controls in Excel, I mean the other ones from the "Form" toolbar... (German version: "Formular")

Can anyone help me out with this? TIA -yves


edit: Today I found that there's also no possibility to read the selected items from a multi-select listbox. At least I didn't find anything in the documentation, again. Seems Excel controls were only intended for display purposes but not to control them by code :(

Quote:

---

Originally posted by Lonelypixel
Today I found that there's also no possibility to read the selected items from a multi-select listbox. At least I didn't find anything in the documentation, again. Seems Excel controls were only intended for display purposes but not to control them by code :(

---

If you are trying to carry out much in the way of advanced actions with data you should be useing a data-base.

it's not about the data nor information, i'm caring. i merely need to automate the excel application for application testing. (i'm in a quality assurance dept.)

by now, i have no problem to find all controls, read their vba name, position and so on. the only thing is that i don't get their (now excel's proprietary controls) caption and lists' multiple selection.