Links

xlLinkSpecifies the type of link.
xlLinkInfoSpecifies the type of information to be returned.
xlLinkInfoTypeSpecifies the type of link.
xlLinkStatusSpecifies the status of a link.
xlLinkTypeSpecifies the type of link.
xlUpdateLinksSpecifies a workbook's setting for updating embedded OLE links.
xlLink
Specifies the type of link.
xlLinkInfo
Specifies the type of information to be returned.
xlLinkInfoType
Specifies the type of link.
xlLinkStatus
Specifies the status of a link.
xlLinkType
Specifies the type of link.
xlUpdateLinks
Specifies a workbook's setting for updating embedded OLE links.

xlLink

Specifies the type of link.

xlExcelLinksLink to an Excel Source (1)
xlOLELinksLink to an OLE DDE link (2)
xlPublishersMacintosh only (5)
xlSubscribersMacintosh only (6)

xlExcelLinks
Link to an Excel Source (1)
xlOLELinks
Link to an OLE DDE link (2)
xlPublishers
Macintosh only (5)
xlSubscribers
Macintosh only (6)

xlLinkInfo

Specifies the type of information to be returned.

xlEditionDateApplies only to editors in Macintosh (2)
xlLinkInfoStatusLink status (3)
xlUpdateStateWhether link updates automatically or manually (1)

xlEditionDate
Applies only to editors in Macintosh (2)
xlLinkInfoStatus
Link status (3)
xlUpdateState
Whether link updates automatically or manually (1)

xlLinkInfoType

Specifies the type of link.

xlLinkInfoOLELinksLink to an OLE or DDE server (2)
xlLinkInfoPublishersMacintosh only (5)
xlLinkInfoSubscribersMacintosh only (6)

xlLinkInfoOLELinks
Link to an OLE or DDE server (2)
xlLinkInfoPublishers
Macintosh only (5)
xlLinkInfoSubscribers
Macintosh only (6)

xlLinkStatus

Specifies the status of a link.

xlLinkStatusCopiedValuesCopied values (10)
xlLinkStatusIndeterminateUnable to determine the status (5)
xlLinkStatusInvalidNameInvalid name (7)
xlLinkStatusMissingFileFile missing (1)
xlLinkStatusMissingSheetWorksheet missing (2)
xlLinkStatusNotStartedNot started (6)
xlLinkStatusOKNo errors (0)
xlLinkStatusOldStatus may be out of date (3)
xlLinkStatusSourceNotCalculatedNot yet calculated (4)
xlLinkStatusSourceNotOpenNot open (8)
xlLinkStatusSourceOpenSource document is open (9)

xlLinkStatusCopiedValues
Copied values (10)
xlLinkStatusIndeterminate
Unable to determine the status (5)
xlLinkStatusInvalidName
Invalid name (7)
xlLinkStatusMissingFile
File missing (1)
xlLinkStatusMissingSheet
Worksheet missing (2)
xlLinkStatusNotStarted
Not started (6)
xlLinkStatusOK
No errors (0)
xlLinkStatusOld
Status may be out of date (3)
xlLinkStatusSourceNotCalculated
Not yet calculated (4)
xlLinkStatusSourceNotOpen
Not open (8)
xlLinkStatusSourceOpen
Source document is open (9)

REMARKS
* Added in 2002.

xlLinkType

Specifies the type of link.

xlLinkTypeExcelLinksLink to an Excel source (1)
xlLinkTypeOLELinksLink to an OLE source (2)

xlLinkTypeExcelLinks
Link to an Excel source (1)
xlLinkTypeOLELinks
Link to an OLE source (2)

xlUpdateLinks

Specifies a workbook's setting for updating embedded OLE links.

xlUpdateLinksAlways(3)
xlUpdateLinksNever(2)
xlUpdateLinksUserSetting(1)

xlUpdateLinksAlways
(3)
xlUpdateLinksNever
(2)
xlUpdateLinksUserSetting
(1)

REMARKS
* Added in 2002.

© 2026 Better Solutions Limited. All Rights Reserved. © 2026 Better Solutions Limited Top