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

Definition

Gets the link date and update status.

public object LinkInfo (string Name, Microsoft.Office.Interop.Excel.XlLinkInfo LinkInfoArgument, object Type, object EditionRef);
abstract member LinkInfo : string * Microsoft.Office.Interop.Excel.XlLinkInfo * obj * obj -> obj
Public Function LinkInfo (Name As String, LinkInfoArgument As XlLinkInfo, Optional Type As Object, Optional EditionRef As Object) As Object

Parameters

Name
String

The name of the link.

LinkInfoArgument
XlLinkInfo

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

Type
Object

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

EditionRef
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.

Returns

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.

Applies to