Class OLEFormat (Excel VBA)

Contains OLE object properties.

Activate

Activates the current OLE object.

Object

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

Set wordObj = Worksheets("Sheet1").OLEObjects(1) 
wordObj.Activate 
With wordObj.Object.Application.WordBasic 
 .StartOfDocument 
 .Insert "This is the beginning" 
 .InsertPara 
End With

Parent

Returns the parent object for the specified object. Read-only.

progID

Returns the programmatic identifiers for the object.

rw = 0 
For Each o in Worksheets(1).OLEObjects 
 With Worksheets(2) 
 rw = rw + 1 
 .cells(rw, 1).Value = o.ProgId 
 End With 
Next

Verb

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

Syntax : expression.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).