Class OLEFormat (Excel VBA)

Contains OLE object properties. To use a OLEFormat class variable it first needs to be instantiated, for example

Activate

Activates the current OLE object.


Dim ole As OLEFormat: Set ole = 
ole.Activate

Object

Returns the OLE Automation object associated with this OLE object. Read-only object.


Dim ole As OLEFormat: Set ole = 
Dim objObject As Object
Set objObject = ole.Object

progID

Returns the programmatic identifiers for the object.


Dim ole As OLEFormat: Set ole = 
Dim strprogID As String
strprogID = ole.progID

Verb

Sends a verb to the server of the specified OLE object.

Verb (Verb)

Verb: The verb that the server of the OLE object should act on. If this argument is omitted, the default verb is sent. The available verbs are determined by the object's source application. Typical verbs for an OLE object are Open and Primary (represented by the XlOLEVerb constants xlOpen and xlPrimary).


Dim ole As OLEFormat: Set ole = 
ole.Verb