OLEObjects Collection Object

Description

A collection of all the OLEObject objects on the specified chart sheet, dialog sheet, or worksheet.

Accessors

Use the OLEObjects method with an argument to access a single member of the collection or without an argument to access the entire collection at once. Use the Add method to create a new OLE object and add it to the collection. The following example creates a new OLE object representing the bitmap file ARCADE.BMP and adds it to worksheet one.


Worksheets(1).OLEObjects.Add fileName:="arcade.bmp"

Properties

Application Property, Border Property, Count Property, Creator Property, Enabled Property, Height Property, Interior Property, Left Property, Locked Property, OnAction Property, Parent Property, Placement Property, PrintObject Property, Shadow Property, Top Property, Visible Property, Width Property, ZOrder Property.

Methods

Add Method (OLEObjects Collection), BringToFront Method, Copy Method, CopyPicture Method, Cut Method, Delete Method, Duplicate Method, Group Method, Item Method, Select Method, SendToBack Method.