This code in VB works:

Dim ws As Worksheet
....
Dim myText As OLEObject
Set myText = ws.OLEObjects("TextBox1")
str = myText.Object.Text

The same in Visual C++ does not (error DISP_E_MEMBERNOTFOUND):

_Worksheet objSheet;
....
TextBox myText;
myText = objSheet.OLEObjects(COleVariant(_T("TextBox1")));
CString str = myText.GetText();

What is an analog in Visual C++ of ".Object" property?