Workbook.LinkSources Method
Returns an Array of links in the workbook.
Namespace: Microsoft.Office.Tools.Excel
Assemblies: Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)
Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)
Syntax
'Declaration
Function LinkSources ( _
Type As Object _
) As Object
Object LinkSources(
Object Type
)
Parameters
Type
Type: System.ObjectOne of the XlLink values specifying the type of links to return.
Return Value
Type: System.Object
An Array of link names in the workbook; nulla null reference (Nothing in Visual Basic) 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.
.NET Framework Security
- Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.