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