OLEFormat Object (Publisher)

Office 2013 and later

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Represents the OLE characteristics, other than linking (see the LinkFormat object), for an OLE object, ActiveX control, or field.

Not all types of shapes and fields have OLE capabilities. Use the Type property for the Shape object to determine into which category the specified shape falls.

Use the Activate and DoVerb methods to automate an OLE object.

Use the OLEFormat property for a shape or field to return an OLEFormat object. The following example activates all OLE objects in the active publication.

Sub ActivateOLEObjects() 
 Dim shpShape As Shape 
 For Each shpShape In ActiveDocument.Pages(1).Shapes 
 If shpShape.Type = pbLinkedOLEObject Then 
 End If 
End Sub