The XML document will provide you with the root of the entire DOM (of type XDoc.DocumentElement). XML DOM nodes in VBAįor the below I will use the following examples XML: The document has been parsed and you can easily traverse the enclosed elements. You have loaded the XML document into memory into the DOMDocument object. XDoc.Load (ThisWorkbook.Path & ' est.xml') XDoc.async = False: XDoc.validateOnParse = False Set XDoc = CreateObject('MSXML2.DOMDocument')

Feel free to change these options if needed. Notice that I am selecting the load to be performed synchronously and not validation be carried out on parsing the document. Let’s look at the example below.īelow we start by loading the XML document. The MSXML2.DOMDocument object allows you to easily traverse through an XML structure an extract any XML node and/or attribute needed. Let’s however, as always, start with a short introduction as to how XML files a structure before we dive into the examples. Fortunately, we can use the MSXML2.DOMDocument object in VBA.

Vb 6 tutorial