Edit

OLEFormat.ProgID property (Word)

  • Article

Returns the programmatic identifier (ProgID) for the specified OLE object. Read-only String.

Syntax

expression. ProgID

expression Required. A variable that represents an 'OLEFormat' object.

Remarks

The ProgID and ClassType properties will (by default) return the same string. However, you can change the ClassType property for DDE links.

For information about programmatic identifiers, see OLE Programmatic Identifiers.

Example

This example loops through all the floating shapes in 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

OLEFormat 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.