Import Method

Microsoft Excel Visual Basic

ShowImport method as it applies to the SoundNote object.

This method should not be used. Sound notes have been removed from Microsoft Excel.

ShowImport method as it applies to the XmlMap object.

Imports data from the specified XML data file into cells that have been mapped to the specified XmlMap object. Returns XlXmlImportResult.

XlXmlImportResult can be one of the following XlXmlImportResult constants
xlXmlImportElementsTruncated The contents of the specified XML data file have been truncated because the XML data file is too large for a cell.
xlXmlImportSuccess The XML data file was successfully imported.
xlXmlImportValidationFailed The contents of the XML data file do not match the specified schema map.

expression.Import(Url, Overwrite)

expression    Required. An expression that returns one of the objects in the Applies To list.

Url    Required String. The path to the XML data to import. The path can be specified in Universal Naming convention (UNC) or Uniform Resource Locator (URL) format. The file can be an XML data file or a valid Office XML data Source Connection (.uxdc) file.

Overwrite    Optional Variant. Set to True to overwrite existing data. Set to False to append to existing data. The default value is False.