UpdateLinks Property

constant indicating a workbook's setting for updating embedded OLE links. Read/write.

expression.UpdateLinks

expression    Required. An expression that returns one of the objects in the Applies To list.

Example

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

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