OpenLinks Method

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)