Workbook.LinkInfo Method (Excel)
Returns the link date and update status.
Syntax
expression .LinkInfo(Name, LinkInfo, Type, EditionRef)
expression A variable that represents a Workbook object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
Name |
Required |
String |
The name of the link. |
LinkInfo |
Required |
The type of information to be returned. |
|
Type |
Optional |
Variant |
One of the constants of XlLinkInfoType specifying the type of link to return. |
EditionRef |
Optional |
Variant |
If the link is an edition, this argument specifies the edition reference as a string in R1C1 style. This argument is required if there's more than one publisher or subscriber with the same name in the workbook. |
Return Value
Variant
Example
This example displays a message box if the link is updated automatically.
If ActiveWorkbook.LinkInfo( _
"Word.Document|Document1!'!DDE_LINK1", xlUpdateState, _
xlOLELinks) = 1 Then
MsgBox "Link updates automatically"
End If