Excel Linking Objects

Comment (1997) Represents a cell comment. The Comment object is a member of the Comments collection.

Application
Author
Creator
Delete()
Next()
Parent
Previous()
Shape
Text([Text], [Start], [Overwrite])
Visible [= setting]

Comments (1997) A collection of cell comments. Each comment is represented by a Comment object.

Application
Count
Creator
GetEnumerator()
Item(Index)
Parent

Hyperlink (1997) Represents a hyperlink. The Hyperlink object is a member of the Hyperlinks collection.

Address [= setting]
AddToFavorites()
Application
CreateNewDocument(Filename, EditNow, Overwrite)
Creator
Delete()
EmailSubject [= setting]
Follow([NewWindow], [AddHistory], [ExtraInfo], [Method], [HeaderInfo])
Name
Parent
Range
ScreenTip [= setting]
Shape
SubAddress [= setting]
TextToDisplay [= setting]
Type

Hyperlinks (1997) Represents the collection of hyperlinks for a worksheet or range. Each hyperlink is represented by a Hyperlink object.

Add(Anchor, Address, [SubAddress], [ScreenTip], [TextToDisplay])
Application
Count
Creator
Delete()
GetEnumerator()
Item
Parent

OLEFormat (1997) Contains OLE object properties.

Activate()
Application
Creator
Object
Parent
progID
Verb([Verb])

OLEObject (1995) Represents an ActiveX control or a linked or embedded OLE object on a worksheet. The OLEObject object is a member of the OLEObjects collection. The OLEObjects collection contains all the OLE objects on a single worksheet.

Activate()
AltHTML [= setting]
Application
AutoLoad [= setting]
AutoUpdate [= setting]
Border
BottomRightCell
BringToFront()
Copy()
CopyPicture([Appearance], [Format])
CreateObjRef(requestedType)
Creator
Cut()
Delete()
Duplicate()
Enabled [= setting]
Equals(obj)
GetHashCode()
GetLifetimeService()
GetType()
GotFocus
Height [= setting]
Index
InitializeLifetimeService()
Interior
Left [= setting]
LinkedCell [= setting]
ListFillRange [= setting]
Locked [= setting]
LostFocus
Name [= setting]
Object
OLEType
OnAction [= setting]
Parent
Placement [= setting]
PrintObject [= setting]
progID
Select([Replace])
SendToBack()
Shadow [= setting]
ShapeRange
SourceName [= setting]
Top [= setting]
TopLeftCell
ToString()
Update()
Verb([Verb])
Visible [= setting]
Width [= setting]
ZOrder

OLEObjectEvents (1995) Hidden or unsupported element.

GotFocus()
LostFocus()

OLEObjects (1995) A collection of all the OLEObject objects on the specified worksheet. Each OLEObject object represents an ActiveX control or a linked or embedded OLE object.

Add([ClassType], [Filename], [Link], [DisplayAsIcon], [IconFileName], [IconIndex], [IconLabel], [Left], [Top], [Width], [Height])
Application
AutoLoad [= setting]
Border
BringToFront()
Copy()
CopyPicture([Appearance], [Format])
Count
Creator
Cut()
Delete()
Duplicate()
Enabled [= setting]
GetEnumerator()
Group()
Height [= setting]
Interior
Item(Index)
Left [= setting]
Locked [= setting]
OnAction [= setting]
Parent
Placement [= setting]
PrintObject [= setting]
Select([Replace])
SendToBack()
Shadow [= setting]
ShapeRange
SourceName [= setting]
Top [= setting]
Visible [= setting]
Width [= setting]
ZOrder

UsedObjects (2002) Represents objects that have been allocated in a workbook.

Application
Count
Creator
GetEnumerator()
Item
Parent