Workbook.UpdateLinks Property

  • Article
Excel Developer Reference

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

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 
  Sub UseUpdateLinks()

Dim wkbOne As Workbook

Set wkbOne = Application.Workbooks(1)

Select Case wkbOne.<strong class="bterm">UpdateLinks</strong>
    Case xlUpdateLinksAlways
        MsgBox "Links will always be updated " &amp; _
            "for the specified workbook."
    Case xlUpdateLinksNever
        MsgBox "Links will never be updated " &amp; _
            "for the specified workbook."
    Case xlUpdateLinksUserSetting
        MsgBox "Links will update according " &amp; _
            "to user settting for the specified workbook."
End Select



End Sub

See Also