How to parse XML in VBA Excel 2003?

Addressing your updated question as specified in your comment.

Addressing your updated question as specified in your comment: You can't instance objects in VBA like that, with an argument in the Dim statement. Try: Dim gReader As XmlTextReader gReader = New XmlTextReader Also, I suggest you read the XmlTextReader documentation here: msdn.microsoft.com/en-us/library/1af7xa5... The examples illustrate how to use XmlTextReader. EDIT: As far as I can tell from a cursory internet search, XmlTextReader is implemented for .

NET but not for VBA. You may want to consider using DOM instead of XmlTextReader. I find DOM relatively easy to use.

The downside is that it is inefficient for very large XML files. Unless you are manipulating large files, DOM should work fine for you. Dim xlmDoc As Object Set xlmDoc = CreateObject("Msxml2.DOMDocument.6.0") xmlDoc.

Load fileName.

So.. first of all.. Thank you for your help. But I couldn't use XmlTextReader. Maybe I am a too noob, but it doesn't work (for me).

I've updated my code so far.. Now I have a reference mismatch :( – Body28 May 16 at 9:30.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.