OLEObject.OLEType Property

Syntax

expression.OLEType

expression A variable that represents an OLEObject 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.

Visual Basic for Applications

Visual Basic for Applications
`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`

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

Discover the type of OLE link? OLE automation object self-contained or external? OLE Type OLE Type Property OLEType OleType Property OLEtype property?

Returns the OLE object type. Can be one of the following XlOLEType constants: xlOLELink or xlOLEEmbed. Returns xlOLELink if the object is linked (it exists outside of the file), or returns xlOLEEmbed if the object is embedded (it's entirely contained within the file). Read-only Long.

See also: