Workbook.LinkSources(Object) Method

Reference

Definition

Namespace:: Microsoft.Office.Tools.Excel

Assemblies:: Microsoft.Office.Tools.Excel.dll, Microsoft.Office.Tools.Excel.v4.0.Utilities.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Returns an Array of links in the workbook.

public object LinkSources (object Type);

abstract member LinkSources : obj -> obj

Public Function LinkSources (Optional Type As Object) As Object

Parameters

Type: Object

One of the XlLink values specifying the type of links to return.

Returns

Object

An Array of link names in the workbook; null if the workbook does not contain any links of the specified Type.

Remarks

The names in the returned Array are the names of the linked documents, editions, or DDE or OLE servers. The format of the array is a one-dimensional array for all types but publisher and subscriber. The returned strings contain the name of the link source, in the appropriate notation for the link type. For example, DDE links use the "Server|Document!Item" syntax.

For publisher and subscriber links, the returned array is two-dimensional. The first column of the array contains the names of the edition, and the second column contains the references of the editions as text.

Optional Parameters

For information on optional parameters, see Optional Parameters in Office Solutions.

Applies to