Macro Sheets Only
Equivalent to choosing the Links command from the Edit menu. Use OPEN.LINKS with the LINKS function to open workbooks linked to a particular sheet.
Syntax
OPEN.LINKS(document_text1, document_text2, ..., read_only, type_of_link)
OPEN.LINKS?(document_text1, document_text2, ..., read_only, type_of_link)
Document_text1, document_text2, are 1 to 12 arguments that are the names of supporting documents in the form of text, or arrays or references that contain text.
Read_only is a logical value corresponding to the read/write status of the linked worksheet. If read_only is TRUE, the sheet can be modified but changes cannot be saved; if FALSE or omitted, changes to the sheet can be saved. Read_only applies only to Microsoft Excel, WKS, and SYLK documents.
Type_of_link is a number from 1 to 6 that specifies what type of link you want to get information about.
Type_of_link Link document type
1 Microsoft Excel link
2 DDE link
3 Reserved
4 Not applicable
5 Subscriber
6 Publisher
Remarks
You can generate an array of the names of linked workbooks with the LINKS function.
Related Functions
CHANGE.LINK Changes supporting workbook links
GET.LINK.INFO Returns information about a link
LINKS Returns the name of all linked workbooks
UPDATE.LINK Updates a link to another document
List of Command-Equivalent Functions