AppendOnImport Property

Microsoft Excel Visual Basic

AppendOnImport Property

Note  XML features, except for saving files in the XML Spreadsheet format, are available only in Microsoft Office Professional Edition 2003 and Microsoft Office Excel 2003.

True if you want to append new rows to XML lists that are bound to the specified schema map when you are importing new data or refreshing an existing connection. False if you want to overwrite the contents of cells that are bound to the specified schema map when you are importing new data or refreshing an existing connection. The default value is False. Read/write Boolean.

expression.AppendOnImport

expression    Required. An expression that returns an XmlMap object.