(Excel) Xml TagPath Property Explained

Demonstrates and explains the TagPath property.

Note: The TagPath property was introduced in Chilkat v9.5.0.77

Download Excel Class Modules Chilkat Excel Class Modules

Dim xml As Chilkat.Xml
Set xml = Chilkat.NewXml

' Load some XML:

success = xml.LoadXml("<a><bbb><ccc><ddd>1</ddd><ddd><z>zzz</z></ddd><ddd>3</ddd></ccc></bbb></a>")

Debug.Print xml.GetXml()

' This is what we have:

' <?xml version="1.0" encoding="utf-8"?>
' <a>
'     <bbb>
'         <ccc>
'             <ddd>1</ddd>
'             <ddd>
'                 <z>zzz</z>
'             </ddd>
'             <ddd>3</ddd>
'         </ccc>
'     </bbb>
' </a>

' The TagPath property is read-only property that returns the unique path to the
' node from the document root.

' For example:

found = xml.SearchForTag2(xml,"z")
If (found = True) Then
    ' We found a node having the tag "z".
    ' The TagPath property tells us the location in the document.

    tagPath = xml.TagPath
    Debug.Print tagPath

    ' The tagPath is bbb|ccc|ddd[1]|z

    ' If we to back to the document root, we can get to the given node via the tagPath.
    xml.GetRoot2 
    Debug.Print xml.Tag
    ' The root tag is "a".

    ' Follow the tagPath to the "z" node:
    found = xml.FindChild2(tagPath)
    Debug.Print "found = "; found; ", tag = "; xml.Tag
    ' We are now at "z".

End If