ClassType Property

Applies To

OLEFormat object.

Description

Returns or sets the class type for the specified OLE object, picture, or field. Read/write String.

Remarks

This property is read-only for linked objects other than DDE links.

You can see a list of the available applications in the Object type box on the Create New tab in the Object dialog box (Insert menu). You can find the ClassType string by inserting an object as an inline shape and then viewing the field codes. The class type of the object follows either the word "EMBED" or the word "LINK."

See Also

ConvertTo method, OLEFormat 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.

For Each s In ActiveDocument.Shapes
    If s.Type = msoLinkedOLEObject Then
        If s.OLEFormat.ClassType = "Excel.Sheet.8" Then
            s.LinkFormat.AutoUpdate = True
        End If
    End If
Next