UpdateChanges Method [Excel 2003 VBA Language Reference]

  • Article

Updates the list on a Microsoft Windows SharePoint Services site with the changes made to the list in the worksheet. Returns Nothing.

expression**.UpdateChanges(iConflictType)**

expression Required. An expression that returns a

Visit ListObject

object.

XlListConflict

XlListConflict can be one of these XlListConflict constants.
xlListConflictDialog default
xlListConflictRetryAllConflicts
xlListConflictDiscardAllConflicts
xlListConflictError

Remarks

This method applies only to lists linked to a SharePoint site. If the SharePoint site is not available, an error is generated.

Example

The following sample updates the list on the SharePoint site with any changes made to the default list in Sheet1 of the active workbook. The sample requires a list in the active workbook that is connected to a SharePoint site.

Sub UpdateListChanges()
   Dim wrksht As Worksheet
   Dim objListObj As ListObject
   
   Set wrksht = ActiveWorkbook.Worksheets("Sheet1")
   Set objListObj = wrksht.ListObjects(1)
         
   objListObj.UpdateChanges xlListConflictDialog
End Sub

Applies to | ListObject Object