Edit

Shape.OLEFormat property (Word)

  • Article

Returns an OLEFormat object that represents the OLE characteristics (other than linking) for the specified shape, inline shape, or field. Read-only.

Syntax

expression.OLEFormat

expression A variable that represents a Shape object.

Example

This example loops through all the floating shapes on the active document and sets all linked Microsoft Excel worksheets to be updated automatically.

For Each s In ActiveDocument.Shapes 
 If s.Type = msoLinkedOLEObject Then 
 If s.OLEFormat.ProgID = "Excel.Sheet" Then 
 s.LinkFormat.AutoUpdate = True 
 End If 
 End If 
Next

See also

Shape Object

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.