Excel form captions + list selection

[Lonelypixel]

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

[Matt_T_hat]

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.

[Lonelypixel]

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.