Looping through an XML to get info

[dontke]

I am trying to create a macro to get info from an XML and parsing using MSXML2. As you can see from the attached pic of the XML below some of the childnodes have the same row number and I am trying to see what the best way is for me to go through the child nodes with the same row number and output that info to the same row line of the spreadsheet. For example I want everything that has row 2 to be on line 13 of the excel, then row 3 will be on line 14 since "i" will increase to 1..

Please Login or Register  to view this content.

[AB33]

Do you mean like this

Please Login or Register  to view this content.

?

[dontke]

The problem is not that, the problem is that there are more than one child nodes for a row. There is a tag for description on one of the child nodes for each row, so if the macro loops to the next node looking for a description and doesn't find anything it automatically gets the description from the next row which is wrong.

By the way I tried pasting the XML info as below and replaced < and > with # since this forum won't allow HTML code format to be posted.

Please Login or Register  to view this content.

[dontke]

Anyone who can help..highly appreciated. Thanks.

[dontke]

Reposting this again. Please help