I'm trying to grab data from an XML document and paste them in a 2D structured Excel sheet. I got most of the way there.
This is where I'm stuck.
As you can see, I can read all the text from elements EXCEPT where the data I need to read is an Attribute of an element. There are two at this stage in the development of my application.
The element 'tie' where the attribute is 'type', and the element 'tied' under the element 'notations' where the attribute is 'type'.
Where it exists, I want to populate the relevant column in my Sheet2. (Columns H and L)
Can someone help please? (I tried hacking various variations of getAttribute but failed as my XML is pretty basic)
I have attached the relevant files. Only 1 sub in the VBA - edit the location of the XML document.