This documentation is archived and is not being maintained.

Workbook.LinkInfo Method

Office 2007
Returns the link date and update status.


expression.LinkInfo(Name, LinkInfo, Type, EditionRef)

expression   A variable that represents a Workbook object.


NameRequired/OptionalData TypeDescription
NameRequiredStringThe name of the link.
LinkInfoRequiredXlLinkInfoThe type of information to be returned.
TypeOptionalVariantOne of the constants of XlLinkInfoType specifying the type of link to return.
EditionRefOptionalVariantIf 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


This example displays a message box if the link is updated automatically.

Visual Basic for Applications
If ActiveWorkbook.LinkInfo( _
        "Word.Document|Document1!'!DDE_LINK1", xlUpdateState, _
            xlOLELinks) = 1 Then
    MsgBox "Link updates automatically"
End If