Accessing a Pre-existing Shape on a Worksheet

excelthoughts · June 21st, 2006, 02:00 AM

I am attempting to access a Shape or Drawing Object on an Excel worksheet to
change its Onaction, ListFillRange and LinkedCell.

In VBA, you did this:

Code:

sheet.DrawingObjects("name").OnAction= "action"
sheet.DrawingObjects("name").ListFillRange= "ListFillRange"

In C#:
I can get access to a Shape object:

Code:

sheet.Shapes.Item("name")

This gives me access to OnAction, but not
ListFillRange or LinkedCell.

I have tried this:

Code:

//gets all Drawing Objects on a sheet
Excel.DrawingObjects d =
(Excel.DrawingObjects)sheet.DrawingObjects(missing)
;
return (Excel.DrawingObjects)d.Item(name);

//crashes here

The problem is that the object [d.Item(name)] is a COM__Object, and it is NOT null, but it cannot be cast to anything useful (like an OLEObject). I do not know what to cast it to to be able to access the properties of the object.

Help!!!!!!!!!!!!!!!
I have spent too long trying to figure this out.
excelthoughts