Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
OpenLinks Method

Workbook.OpenLinks Method

Office 2007
Opens the supporting documents for a link or links.


expression.OpenLinks(Name, ReadOnly, Type)

expression   A variable that represents a Workbook object.


NameRequired/OptionalData TypeDescription
NameRequiredStringThe name of the Microsoft Excel or DDE/OLE link, as returned from the LinkSources method.
ReadOnlyOptionalVariantTrue to open documents as read-only. The default value is False.
TypeOptionalVariantOne of the constants of XlLink that specifies the link type.


This example opens OLE link one in the active workbook.

Visual Basic for Applications
linkArray = ActiveWorkbook.LinkSources(xlOLELinks)
ActiveWorkbook.OpenLinks linkArray(1)

This example opens all supporting Microsoft Excel documents for the active workbook.

Visual Basic for Applications
Sub OpenAllLinks()
    Dim arLinks As Variant
    Dim intIndex As Integer
    arLinks = ActiveWorkbook.LinkSources(xlExcelLinks)
    If Not IsEmpty(arLinks) Then
        For intIndex = LBound(arLinks) To UBound(arLinks)
            ActiveWorkbook.OpenLinks arLinks(intIndex)
        Next intIndex
        MsgBox "The active workbook contains no external links."
    End If
End Sub

Community Additions

© 2015 Microsoft