Parse XML using VBA

Question

I have few hundreds of XML files created by Lotus Notes. I need to parse each of these files to fetch value of the attribute form. This attribute is part of the NameSpace at the top of the XML.

I am new to working with XML and any pointers will be quite helpful.

    <?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE document SYSTEM "xmlschemas/domino_7_0_2.dtd">
    <document xmlns="http://www.lotus.com/dxl" version="7.0" maintenanceversion="3.0" replicaid="8025762C004A879B" form="Memo">
      <noteinfo noteid="99212e" unid="8025762C004DD80B80256CA200440BB0" sequence="1">
        <created>
          <datetime>20030102T122314,40+00</datetime>
        </created>
        <modified>
          <datetime>20100319T031007,91+00</datetime>
        </modified>
        <revised>
          <datetime>20030102T122948,71+00</datetime>
        </revised>
        <lastaccessed>
          <datetime>20100319T031007,90+00</datetime>
        </lastaccessed>
        <addedtofile>
          <datetime>20100319T031007,90+00</datetime>
        </addedtofile>
      </noteinfo>
    </document>

question from:https://stackoverflow.com/questions/65893579/parse-xml-using-vba

Answer 1

Waitting for answers