Share via

OLEFormat.Object Property

  • Article
Excel Developer Reference

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

Syntax

expression.Object

expression   A variable that represents an OLEFormat object.

Example

This example inserts text at the beginning of an embedded Word document object on Sheet1. Note that the three statements in the With control structure are WordBasic statements.

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

See Also