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.

Syntax

expression.OpenLinks(Name, ReadOnly, Type)

expression   A variable that represents a Workbook object.

Parameters

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.

Example

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
    Else
        MsgBox "The active workbook contains no external links."
    End If
End Sub



Community Additions

ADD
Show:
© 2015 Microsoft