Syntax
Private Sub Workbook_AfterXmlImport(ByVal Map As XmlMap, ByVal IsRefresh As Boolean, ByVal Result As XlXmlImportResult)
Enter
Code
End Sub
This event will run after importing a new or
refreshing an already created XML map within this specific excel workbook.
Required Parameters
Map
The map parameter returns the exported XML
map as an XMLMap object. This allows
users to manipulate the XML map or display various XML map attributes.
IsRefresh
The IsRefresh parameter returns a value of
True if the XML map is being refreshed and returns a value of false if the XML
map is being imported for the first time.
Result
The result parameter can return three
different values. If the XML map being refreshed or imported contains too much
data to fit into the workbook then the result parameter will return the value
of xlXmlImportElementsTruncated. If the XML map being refreshed or imported is
successful then the result parameter will return a value of xlXmlImportSuccess.
If the XML map being refreshed or imported does not match the XML schema
specified then the result parameter will return a value of
xlXmlImportValidationFailed.
