Traversing all nodes in an XML file with VBScript
Please, try this: set nodes = xmlDoc.selectNodes(“//*”) for i = 0 to nodes.length document.write(nodes(i).nodeName & ” – ” & nodes(i).text & “<br />”) next
xmldom
Obtain attribute names from XML using VBA
Displaying XML structures including attributes via recursive function calls My example code demonstrates a way to [1] assign the entire XML structure to a 2-dim array using XMLDOM methods and [2] optionally write it back to a sheet. Amplifying hints: I added these ► structured hints to offer more help than by displaying code only, … Read more