ListObject.UpdateChanges Method (2003 System)

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

Namespace:  Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)

Syntax

'Declaration
Public Sub UpdateChanges ( _
    iConflictType As XlListConflict _
)
'Usage
Dim instance As ListObject
Dim iConflictType As XlListConflict

instance.UpdateChanges(iConflictType)
public void UpdateChanges(
    XlListConflict iConflictType
)

Parameters

Remarks

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

Examples

The following code example uses the UpdateChanges method to submit changes that were made in an existing ListObject to a Web site that is running Microsoft Windows SharePoint Services. This example assumes that the worksheet contains a ListObject named List1 that has already been published to a Web site running Microsoft Windows SharePoint Services.

Private Sub ListObject_UpdateChanges()
    Me.customerListObject.UpdateChanges( _
        Excel.XlListConflict.xlListConflictDialog)
End Sub

private void ListObject_UpdateChanges()
{
    this.customerListObject.UpdateChanges(
        Excel.XlListConflict.xlListConflictDialog);
}

Permissions

See Also

Reference

ListObject Class

ListObject Members

Microsoft.Office.Tools.Excel Namespace