LinkInfo Method
Returns the link date and update status. Variant.
expression.LinkInfo(Name, LinkInfo, Type, EditionRef)
expression Required. An expression that returns one of the objects in the Applies To list.
Name Optional String.
LinkInfo Required XlLinkInfo. The type of information to be returned.
| XlLinkInfo can be one of these XlLinkInfo constants. |
| xlEditionDate |
| xlLinkInfoStatus |
| xlUpdateState This method returns 1 if the link updates automatically, or it returns 2 if the link must be updated manually. |
Type Optional XlLinkInfoType. The type of link to return.
| XlLinkInfoType can be one of these XlLinkInfoType constants. |
| xlLinkInfoOLELinks (also handles DDE links) |
| xlLinkInfoPublishers |
| xlLinkInfoSubscribers |
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.
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