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. |