I have never dealt with XML directly and
(by the sound of it I am lucky!) and was only answering the specific question.


I thought MS sold or gave away an XML parser  that pulls the XML into excel.
But this was in the early days of XML. Many years ago - well, about 6 or 7
years, I suppose.

Anyhow, if I was faced with that problem I would try googling and see if
someone has already done it.