asked on
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.
That is,
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.
Thanks.
Sun-King-201607012.xml
Book1-EE-question.xlsm
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.
That is,
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.
Thanks.
Sun-King-201607012.xml
Book1-EE-question.xlsm
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.