Class OLEFormat (Word VBA)

The class OLEFormat represents the OLE characteristics (other than linking) for an OLE object, ActiveX control, or field.

The classes Field, InlineShape and Shape. give access to class OLEFormat

To use a OLEFormat class variable it first needs to be instantiated, for example

Dim ole as OLEFormat
Set ole = ActiveDocument.Fields(1).OLEFormat

The following procedures can be used to set variables of type OLEFormat: Field.OLEFormat, InlineShape.OLEFormat and Shape.OLEFormat.


Activate - Activates the specified OLEFormat object.

ActivateAs - Sets the Windows registry value that determines the default application used to activate the specified OLE object.

ConvertTo - Converts the specified OLE object from one class to another, making it possible for you to edit the object in a different server application or change how the object is displayed in the document.

DoVerb - Requests that an OLE object perform one of its available verbs—the actions an OLE object takes to activate its contents.

Edit - Opens the specified OLE object for editing in the application it was created in.

Open - Opens the specified OLEFormat object.


ClassType returns or sets the class type for the specified OLE object, picture, or field.

DisplayAsIcon true if the specified object is displayed as an icon.

IconIndex returns or sets the icon that is used when the DisplayAsIcon property is True.

IconLabel returns or sets the text displayed below the icon for an OLE object.

IconName returns or sets the program file in which the icon for an OLE object is stored.

IconPath returns the path of the file in which the icon for an OLE object is stored.

Label returns a string that's used to identify the portion of the source file that's being linked.

Object returns an object that represents the specified OLE object's top-level interface. .

PreserveFormattingOnUpdate true preserves formatting done in Microsoft Word to a linked OLE object, such as a table linked to a Microsoft Excel spreadsheet.

ProgID returns the programmatic identifier (ProgID) for the specified OLE object.