Import Method [Excel 2003 VBA Language Reference]

  • Article

Import method as it applies to the SoundNote object.

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

Import method as it applies to the XmlMap object.

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 the worksheet.
xlXmlImportSuccess The XML data file was successfully imported.
xlXmlImportValidationFailed The data being imported failed schema validation, but was imported anyway.

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.

Remarks

If either of the following conditions is true, a runtime error will occur. If more than one condition is true, Excel returns a runtime error for the most severe (they are listed below with the most severe listed first):

  • If the XML data contains syntactical errors.
  • If import is cancelled because not all of the data could fit in the worksheet.

Applies to | SoundNote Object | XmlMap Object

See Also | Play Method | Record Method