Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
FollowHyperlink to OLEObject | Excel Programming | |||
de-activating OLEObject | Excel Programming | |||
OLEObject GetFocus | Excel Programming | |||
OLEObject on worksheet. Trying to get value from it. | Excel Programming | |||
OLEobject on the sheet | Excel Programming |