Programming Excel with VBA and .NET

Name

oleobject.Add([ClassType], [Filename], [Link], [DisplayAsIcon], [IconFileName], [IconIndex], [IconLabel], [Left], [Top], [Width], [Height])

Synopsis

Creates a new OLE object on a sheet.

Argument	Settings
ClassType	The programmatic ID of the object to create. For example "Word.Document" or "MSGraph.Chart".
Filename	The filename of the object to create. You must specify ClassType or Filename.
Link	True links the object to Filename; False makes a copy of Filename to store in the workbook.
DisplayAsIcon	True displays the object as an icon or a picture; False renders the object in the worksheet.
IconFileName	If DisplayAsIcon is True, specifies a file containing the icon to display.
IconIndex	If DisplayAsIcon is True, specifies the index of the icon within the icon file. Default is the first icon in the file.
IconLabel	If DisplayAsIcon is True, specifies the text to display beneath the icon.
Left	The distance between cell A1 and the left edge of the object in point.
Top	The distance between cell A1 and the top edge of the object in point.
Width	The width of the object in points.
Height	The height of the object in points.

Tip

The Width and Height arguments aren’t absolute. Their actual result depends on the OLE object being created.

The following code creates a new embedded Word document on the active worksheet:

Sub AddObject( ) Dim ws As Worksheet, ole Set ws = ActiveSheet ' Create the object. Set ole = ws.OleObjects.Add("Word.Document", ...