Partager via


OLEFormat Object (PowerPoint)

Contains properties and methods that apply to OLE objects.

Remarks

The LinkFormat object contains properties and methods that apply to linked OLE objects only. The PictureFormat object contains properties and methods that apply to pictures and OLE objects.

Example

Use the OLEFormat property to return an OLEFormat object. The following example loops through all the shapes on all the slides in the active presentation and sets all linked Microsoft 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

    Next

Next

See Also

Concepts

PowerPoint Object Model Reference

OLEFormat Object Members