Best practise for importing XML file into Excel via VBA

Hello all,

I need to set a system up to be able to import elements of a standard XML file into specific columns in an Excel spreadsheet. This system needs to be set up so that users can basically click a button and then select the XML file which will then be imported into relevant columns - though most of the XML file won't be used.

Is the best practise here to write an XSLT to get the data I want or would it be to use MSXML2.DOMDocument to cycle through to get to relevant elements and pull that way?

I know VBA but am new to XML so if there is any tutorial anyone can recommend on using DOMDocument that would be really helpful - I've found example code on internet but don't really know how to find specific nested data so could do with an explanation of how to cycle through all nodes etc. in VBA if possible.

Many thanks for any help.

By the way - for info the XML schema is located here http://www.teachernet.gov.uk/managem...ers/CTF/CTF10/ (by clicking on schema link) - but I will only need to pull a very small amount of data out of this.

Many thanks for any help.