Share via

Shape.OLEFormat Property

  • Article
Word Developer Reference

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.

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