Applies To
Workbook Object.
Description
Opens the supporting documents for a link or links.
Syntax
object.OpenLinks(name, readOnly, type)
object
Required. The Workbook object.
name
Required. Specifies the name of the Microsoft Excel or DDE/OLE link, as returned from the LinkSources method (can be an array of names to specify more than one link).
readOnly
Optional. True if the documents are opened read-only. False if omitted.
type
Optional. Specifies the link type. Can be one of xlExcelLinks, xlOLELinks (also handles DDE links), xlPublishers, or xlSubscribers. xlExcelLinks if omitted.
Example
This example opens OLE link one in the active workbook.
linkArray = ActiveWorkbook.LinkSources(xlOLELinks) ActiveWorkbook.OpenLinks linkArray(1)
This example opens all supporting Microsoft Excel documents for the active workbook.
ActiveWorkbook.OpenLinks _ name:=ActiveWorkbook.LinkSources(xlExcelLinks)