Workbook.OpenLinks (Excel)

Opens the supporting documents for a link or links.

OpenLinks (Name, ReadOnly, Type)


Dim strName As String: strName = 
ActiveWorkbook.OpenLinks Name:=strName

Arguments

The following argument is required

Name (String) - The name of the Microsoft Excel or DDE/OLE link, as returned from the LinkSources method.

Optional arguments

The following arguments are optional

ReadOnly (Boolean) - True to open documents as read-only. The default value is False.

Type (XlLink) - One of the constants of XlLink that specifies the link type.


Possible values are

xlExcelLinks The link is to an Excel worksheet.
xlOLELinks The link is to an OLE source.
xlPublishers Macintosh only.
xlSubscribers Macintosh only.