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
Bookmarks