OLEFormat Object

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:

• Microsoft PowerPoint Object Model Overview
• OLEFormat Object Members