Leveraging DOM and XPath to Manipulate XML Files : Excel XML « Excel « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Excel
  3. Excel XML

Leveraging DOM and XPath to Manipulate XML Files

 
     Sub Load_ReadXMLDoc()
         Dim oMyDoc As DOMDocument
         Set oMyDoc = New DOMDocument
         oMyDoc.async = False
         oMyDoc.Load (ThisWorkbook.Path & "\SalesByRegion.xml")
         Debug.Print oMyDoc.XML
         Set oMyDoc = Nothing
     End Sub








Related examples in the same category

1.Get Schema
2.returns a workbook object with the XML data mapped to your spreadsheet:
3.Programmatically Changing XML Map Properties
4.Refresh Your XML Data
5.Creating Your Own XSD
6.Importing Data into an Existing XML Map
7.Exporting to an XML File
8.Using DOM with ADO to Convert Excel Data to XML
9.Compatibility Mode
10.XML transform
11.Export to XML file