Reading XML file using VBA

Hi,

I want to read a particular part of an XMl file into Excel using VBA.
So far I have managed to load the XML file using this code:

Hi,

I am trying to extract certain data from a XML file using Excel VBA.

So far, I have managed to load the file using this code:

Please Login or Register  to view this content.

I now want to extract the section highlighted in yellow in my attachment (please see attachment).
How do I get that part?

Hi,

Is there anyone out there that knows how to read XML files using VBA?

Thank You

Hi,

Can you attach the xml file? Thank you!

It is the file attached to the very first message.

Hi,

You attached an image of the xml file, can you attach the actual xml file?

Oh, silly me.
Ok, I don't have that file with me right now, but will it attach next week when i'm at work.
thank you.

So a rough attempt looking at your image file :D

Please Login or Register  to view this content.