Workbook.LinkInfo Method

  • Article
Excel Developer Reference

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

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

See Also