Custom Search

Microsoft xml parser manual

  1. in excel record a macro name it xmltest
  2. type some random text. Stop the recording and get into the vba editor (alt+F11)
  3. Find from the menus tools:references and add a reference to the xml parser com dll
  4. type XMLHTTP into
  5. you will get  read this
  6. then copy the code to the macro you are writing, like this (make sure you dim xml as then intellisense will start working)

    Dim xml As MSXML2.XMLHTTP

    Set xml = New MSXML2.XMLHTTP

    xml.Open "GET", ""


    Dim doc As MSXML2.DOMDocument

    Set doc = New MSXML2.DOMDocument


    doc.Load xml.responseXML

    Dim r As Range

    Set r = Range("a2")

    r.Value = doc.xml


If you need https you might need an updated xml parser com dll. It is on


Or for short

Make sure you also get the xmlinst.exe tool as you will need it if the computer starts behaving badly.

Key is in the MSXML2.XMLHTTP

The way com works is that you have a default version (MSXML2) and then the real versions (MSXML2.26 MSXML2.3 etc) so you can use MSXML2.3.XMLHTTP


So once you install 3.0 you can set default back to 2.6 but still use the 3.0


Just search the registry for MSXML and you will get the idea.

Click here to see more economics,politics and school papers from me