Workbook.LinkInfo Method

Gets the link date and update status.

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 LinkInfo ( _
    Name As String, _
    LinkInfoArgument As XlLinkInfo, _
    Type As Object, _
    EditionRef As Object _
) As Object

Object LinkInfo(
    string Name,
    XlLinkInfo LinkInfoArgument,
    Object Type,
    Object EditionRef
)

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.

Remarks

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.

See Also

Reference

Workbook Interface

Microsoft.Office.Tools.Excel Namespace