OLEObject question
 

Hi,

In FoxPro I added to a Excel sheet few fields :

_control=xlref.activesheet.oleobjects.add('Forms.t extbox.1')
_control.Object.Value="New Value"
....
The xls files were created a long time ago and now, I need to parse them.

Now in C# 2003 + PIA's, how can I access the oleObjects properties ?

I tried :
Excel.OLEObjects oleObjects =
(Excel.OLEObjects)wrkSheet.OLEObjects(Type.Missing );

foreach(Excel.OLEObject oleObject in oleObjects)

{

oleObject.Enabled = true; // it's working

BUT to what should I cast oleObject.Object ?? to access its Value property.

}

Excel.TextBoxes txtBoxes =
(Excel.TextBoxes)wrkSheet.TextBoxes(Type.Missing); returns 0 elements.


Or maybe I just need a different approach.

Thanks for any advice.