retrieving node names

hi i have been struggling with get node names extracted from an xml file

i want the vba code below to return all nodes as following
e.g
ParentNodeName/ChildNodeName
ParentNodeName
ParentNodeName
ParentNodeName/ChildNodeName/ChildNodeName

the xml has tuples and there are tuples within tuples. I just need the code to return all elements with parentnode name in front of it.

Tried playing around with the following code but with no luck. Can someone please advise?

Please Login or Register  to view this content.

Maybe inside the for ...Next is missing:

Please Login or Register  to view this content.

Thank you Bebo. I added the bit you mentioned but it didnt work for me.
I did come up with the code below which does the job. I dont need parentnodes "xbrli" and "#document" so i am setting them to vbNullString

I dont feel a 100% satisfied(too many lines of code!) with it but it does the job. I am pretty sure this can be shorten down to a few lines but not sure how. Thank you for your input

Please Login or Register  to view this content.