ChartSheet.OLEObjects(Object) Method

Definition

Gets an object that represents either a single OLE object (an OLEObject) or a collection of all OLE objects (an OLEObjects collection) on the chart or sheet.

public object OLEObjects (object Index);
abstract member OLEObjects : obj -> obj
Public Function OLEObjects (Optional Index As Object) As Object

Parameters

Index
Object

The name or number of the OLE object.

Returns

Examples

The following code example uses the OLEObjects method to get the collection of OLE objects on the current Microsoft.Office.Tools.Excel.ChartSheet.

private void DisplayOLEObjectsCount()
{
    Globals.Sheet1.Range["A1", "A5"].Value2 = 22;
    Globals.Sheet1.Range["B1", "B5"].Value2 = 55;

    this.SetSourceData(Globals.Sheet1.Range["A1", "B5"],
        Excel.XlRowCol.xlColumns);
    this.ChartType = Excel.XlChartType.xl3DColumn;

    Excel.OLEObjects oleObjects1 =
        (Excel.OLEObjects)this.OLEObjects();
    MessageBox.Show("The chart sheet has " + oleObjects1.Count +
        " OLE objects.");
}
Private Sub DisplayOLEObjectsCount()
    Globals.Sheet1.Range("A1", "A5").Value2 = 22
    Globals.Sheet1.Range("B1", "B5").Value2 = 55

    Me.SetSourceData(Globals.Sheet1.Range("A1", "B5"), _
        Excel.XlRowCol.xlColumns)
    Me.ChartType = Excel.XlChartType.xl3DColumn

    Dim oleObjects1 As Excel.OLEObjects = _
        CType(Me.OLEObjects(), Excel.OLEObjects)
    MsgBox("The chart sheet has " & oleObjects1.Count & _
        " OLE objects.")
End Sub

Applies to