LinkSources Method

Microsoft Excel Visual Basic

expression.LinkSources(Type)

expression    Required. An expression that returns one of the objects in the Applies To list.

Type   Optional XlLink. The type of link to return.

XlLink can be one of these XlLink constants.
xlExcelLinks
xlOLELinks (also handles DDE links)

xlPublishers

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.

Example

This example displays a list of OLE and DDE links in the active workbook. The example should be run on a workbook that contains one or more linked Word objects.

aLinks = ActiveWorkbook.LinkSources(xlOLELinks)
If Not IsEmpty(aLinks) Then
    For i = 1 To UBound(aLinks)
        MsgBox "Link " & i & ":" & Chr(13) & aLinks(i)
    Next i
End If