ListObject.UpdateChanges Method

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
Sub UpdateChanges ( _
    iConflictType As XlListConflict _
)
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.

This example is for a document-level customization.

Private Sub ListObject_UpdateChanges()
        Me.customerListObject.UpdateChanges( _
            Excel.XlListConflict.xlListConflictDialog)
    End Sub
private void ListObject_UpdateChanges()
{
    this.customerListObject.UpdateChanges(
        Excel.XlListConflict.xlListConflictDialog);
}

.NET Framework Security

See Also

Reference

ListObject Interface

Microsoft.Office.Tools.Excel Namespace