Workbook.LinkInfo Method
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 |
|---|
|