Update Method

Applies To

Section object.

Description

Updates the specified section, but doesn't save changes made to the binder. Use the Save method to save changes to the binder.

Syntax

expression.Update

expression Required. An expression that returns a Section object.

Remarks

The Update method is useful if several sections need to be updated before the binder is saved.

Example

This example adds a Microsoft Excel worksheet to an existing binder, inserts a value in the worksheet, and updates the new section. Without the Update method, the change would be lost when the new Section object is set to Nothing. (Use the Save method to permanently save these changes to the binder.)

Set newBinder = GetObject("C:\Binder1.obd", "OfficeBinder.Binder")
Set newSection = newBinder.Sections.Add(Type:="Excel.Sheet")
With newSection
    .Object.Worksheets(1).Range("a1").Value = 3.14159
    .Update
End With
Set newSection = Nothing