OLEFormat.ProgID property (PowerPoint)

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


expression. ProgID

expression A variable that represents a OLEFormat object.

Return value



This example loops through all the objects on all the slides in the active presentation and sets all linked Microsoft Office Excel worksheets to be updated manually.

For Each sld In ActivePresentation.Slides

    For Each sh In sld.Shapes

        If sh.Type = msoLinkedOLEObject Then

            If sh.OLEFormat.ProgID = "Excel.Sheet" Then

                sh.LinkFormat.AutoUpdate = ppUpdateOptionManual

            End If

        End If



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.