Programming Excel with VBA and .NET

Name

xmlmap.IsExportable

Synopsis

Returns True if the XML map can be exported, False if it cannot. Use the IsExportable property to test if the relationships established in a mapped list or range allow the data contained there to be exported.

Some types of XML data can be imported but not exported, and some lists can create denormalized data that can’t be exported. See the earlier section "Approaches to Using XML Maps" for details on what types of data can be exported.

The following code tests if a map can be exported before attempting to export it to a file:

Set xmap = ThisWorkbook.XmlMaps("Numbers_Map")
If xmap.IsExportable Then
   res = xmap.Export("Numbers.xml")
End If