Workbook.UpdateLinks Property

Syntax

expression.UpdateLinks

expression A variable that represents a Workbook object.

Remarks

XlUpdateLinks can be one of these XlUpdateLinks constants.

xlUpdateLinksAlways Embedded OLE links are always updated for the specified workbook.

xlUpdateLinksNever Embedded OLE links are never updated for the specified workbook.

xlUpdateLinksUserSetting Embedded OLE links are updated according to the user's settings for the specified workbook.

Example

In this example, Microsoft Excel determines the setting for updating links and notifies the user.

Visual Basic for Applications

Visual Basic for Applications
`Sub UseUpdateLinks() Dim wkbOne As Workbook Set wkbOne = Application.Workbooks(1) Select Case wkbOne.UpdateLinks Case xlUpdateLinksAlways MsgBox "Links will always be updated " & _ "for the specified workbook." Case xlUpdateLinksNever MsgBox "Links will never be updated " & _ "for the specified workbook." Case xlUpdateLinksUserSetting MsgBox "Links will update according " & _ "to user settting for the specified workbook." End Select End Sub`

Sub UseUpdateLinks() Dim wkbOne As Workbook Set wkbOne = Application.Workbooks(1) Select Case wkbOne.UpdateLinks Case xlUpdateLinksAlways MsgBox "Links will always be updated " & _ "for the specified workbook." Case xlUpdateLinksNever MsgBox "Links will never be updated " & _ "for the specified workbook." Case xlUpdateLinksUserSetting MsgBox "Links will update according " & _ "to user settting for the specified workbook." End Select End Sub

update update links UpdateLinks updatelinks property

Returns or sets an XlUpdateLink constant indicating a workbook's setting for updating embedded OLE links. Read/write.

See also: