Excel.Worksheet.OLEObjects.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
Worksheet.OLEObjects method (Excel)	vbaxl10.chm175108	vbaxl10.chm175108	Excel.Worksheet.OLEObjects	3f178081-2a42-a751-ae79-8ca149d8ec45	05/30/2019	medium

Worksheet.OLEObjects method (Excel)

Returns 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. Read-only.

Syntax

expression.OLEObjects (Index)

expression A variable that represents a Worksheet object.

Parameters

Name	Required/Optional	Data type	Description
Index	Optional	Variant	The name or number of the OLE object.

Return value

Object

Example

This example creates a list of link types for OLE objects on Sheet1. The list appears on a new worksheet created by the example.

Set newSheet = Worksheets.Add 
i = 2 
newSheet.Range("A1").Value = "Name" 
newSheet.Range("B1").Value = "Link Type" 
For Each obj In Worksheets("Sheet1").OLEObjects 
 newSheet.Cells(i, 1).Value = obj.Name 
 If obj.OLEType = xlOLELink Then 
 newSheet.Cells(i, 2) = "Linked" 
 Else 
 newSheet.Cells(i, 2) = "Embedded" 
 End If 
 i = i + 1 
Next

[!includeSupport and feedback]