Share via


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

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.

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

See Also

Concepts

Workbook Object Members

Workbook Object