Workbook.LinkInfo Method (String, XlLinkInfo, Object, Object)

 

Gets the link date and update status.

Namespace:   Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)

Function LinkInfo (
	Name As String,
	LinkInfoArgument As XlLinkInfo,
	Type As Object,
	EditionRef As Object
) As Object

Parameters

Name
Type: System.String

The name of the link.

LinkInfoArgument
Type: Microsoft.Office.Interop.Excel.XlLinkInfo

One of the XlLinkInfo values that specifies the type of information to return.

Type
Type: System.Object

One of the XlLinkInfoType values that specifies the type of link to return information for.

EditionRef
Type: System.Object

If the link is an edition, this parameter specifies the edition reference as a string in R1C1 style. EditionRef is required if there is more than one publisher or subscriber with the same name in the workbook.

Return Value

Type: System.Object

A value that indicates information about the link. If LinkInfoArgument is xlUpdateState, this method returns 1 if the link updates automatically, or 2 if the link must be updated manually.

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

Return to top
Show: