Pulling in data to excel from XML messages

Hello

Im hoping someone can help point me in the right direction and start me off on this one.

I have a folder of XML messages and I would like to bring these XML messages into Excel and create a summary report.

I am wondering how you work with XML messages in Excel and how I only pull in certain fields as the messages contain a lot of information which is irrelevant.

I have attached a copy of a dummy XML message and also attached an example output.

From the example you will see I am interested in only pulling in the following tags from the XML message.

• Status
• DealRef
• TradeRef
• Qty

Any pointers would be greatly appreciated.

I am really only interested in how you cut the XML message up at this point as Im sure I can work out how to loop through the folder etc.

Thanks

McCrimmon