Returns an array of links in the workbook. The names in the array are the names of the linked documents, editions, or DDE or OLE servers. Returns Empty if there are no links.
Syntax
expression.LinkSources(Type)
expression Required. An expression that returns a Workbook object.
Type Optional. The type of link to return. Can be one of the following XlLink constants: xlExcelLinks, xlOLELinks (also handles DDE links), xlPublishers, or xlSubscribers.
Remarks
The format of the array is a one-dimensional array for all types but publisher and subscriber. The returned strings contain the name of the link source, in the appropriate notation for the link type. For example, DDE links use the "Server|Document!Item" syntax.
For publisher and subscriber links, the returned array is two-dimensional. The first column of the array contains the names of the edition, and the second column contains the references of the editions as text.