Home Library Learn Downloads Support Community
Sign in | United States - English | |
2 out of 4 rated this helpful - Rate this topic

Worksheet.OLEObjects Method

Visual Studio 2005

Gets an object that represents either a single OLE object (an Microsoft.Office.Interop.Excel.OLEObject) or a collection of all OLE objects (an Microsoft.Office.Interop.Excel.OLEObjects collection) on the worksheet.

Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel (in microsoft.office.tools.excel.dll)

C#
VB
Copy 
public virtual Object OLEObjects (
	[OptionalAttribute] Object Index
)

Parameters

Index

The name or number of the OLE object.

Return Value

An object that represents either a single OLE object (an Microsoft.Office.Interop.Excel.OLEObject) or a collection of all OLE objects (an Microsoft.Office.Interop.Excel.OLEObjects collection) on the worksheet.

Optional Parameters

For information on optional parameters, see Understanding Optional Parameters in COM Interop.

The following code example uses the OLEObjects method to display the number of OLE objects in the current worksheet.

C#
VB
Copy 
private void DisplayOLEObjectsCount()
{
    Excel.OLEObjects oleObjects1 = (Excel.OLEObjects)this.OLEObjects(missing);
    MessageBox.Show("There are " + oleObjects1.Count + " OLE objects in " +
        "this worksheet.");
}
Did you find this helpful?
(1500 characters remaining)