Using MSXML to get the list of unique tags

[AthmanArumugam]

Hi,

I have an assignment , wherein I have to traverse each node and get the unique tag and put them into an excel sheet. I am planning to use MSXML reference DLL, however I haven't used it. Is there a good blog that would help me understand working with MSXML and can traverse the nodes.

Attached is the XML file that I need to work with.
Also I have attached the resultant excel file which I need o generate using a VBA code.

Thanks and Regards
Athman

 

[AthmanArumugam]

Find attached the XML file. As the file size of the excel is huge , unable to attach I here. Basically, what I am expected to do is create a macro that would take out the tags between two Lender Transactions and create columns out of it.

I should makes sure that I don't repeat the columns but have only unique columns.

 

[Chihiro]

First, add Microsoft XML 2.0 or 6.0 to your project reference.

Then go through links.
https://msdn.microsoft.com/en-gb/library/aa468547.aspx
https://www.w3schools.com/xml/dom_intro.asp
https://msdn.microsoft.com/en-us/library/windows/desktop/ms766487(v=vs.85).aspx

Oh and below is pretty good resource as well (late binding method used).
http://analystcave.com/vba-xml-working-xml-files/

 

[Chihiro]

Oh just as FYI, if you have access to PowerQuery.

It's much easier to read xml file.

 

[AthmanArumugam]

Hi Chihiro,

Thanks very much. This is the information which I was waiting for.

 

[AthmanArumugam]

Oh just as FYI, if you have access to PowerQuery.

It's much easier to read xml file.

View attachment 44512

Thanks so much. This is very simple.

 

[AthmanArumugam]

Thanks so much. This is very simple.

Hi Chihiro,

I installed Power Query and it is very simple. Thanks to Chandoo for this open source forum.