I have a COM+ control written in C++ that I wand to use in an Excel sheet.
I can drop one into the sheet visually no problem ,add a button and talk
to my control just fine.

Then I tried to create an instance of the control programmatically
instead, inside the click code of a button. I don't want to actually add
it to the sheet, I just want to create it, query it and stick the results
in a cell. I can't get this to work. The nearest I can get is using the
OLEObjects collection of the workbook, but adding it into there actually
adds it to the sheet. Is this just the way Excel has to work, i.e.
anything you create from a control has to be contained in a sheet to work
??

--
* Need help running those old FoxPro / xBase apps on modern systems ?
* http://www.hentzenwerke.com/catalogp.../painlesse.htm