(Excel) Demonstrate XML SearchForTag2

Demonstrates how to use SearchForTag2.

Download Excel Class Modules Chilkat Excel Class Modules

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

' Load the following XML:

' 	<Test>
' 	    <testchild1>
' 	        test
' 	    </testchild1>
' 	    <testchild1>
' 	        test1
' 	    </testchild1>
' 	    <testchild1>
' 	        test2
' 	    </testchild1>
' 	    <testchild1>
' 	        test3
' 	    </testchild1>
' 	    <testchild1>
' 	        test4
' 	    </testchild1>
' 	    <testchild1>
' 	        test5
' 	    </testchild1>
' 	    <testchild1>
' 	        test6
' 	    </testchild1>
' 	</Test>


success = xml.LoadXml("<Test><testchild1>test</testchild1><testchild1>test1</testchild1><testchild1>test2</testchild1><testchild1>test3</testchild1><testchild1>test4</testchild1><testchild1>test5</testchild1><testchild1>test6</testchild1></Test>")


i = 0

Set xmlSearch = xml.GetRoot()

Set afterPtr = xml.GetRoot()

' Alway begin the search from the root.
Do While xmlSearch.SearchForTag2(afterPtr,"testchild1")
    ' If successful, xmlSearch now points to the found element.
    i = i + 1

    ' Set afterPtr = xmlSearch (so we find the next match after the one we just found)
    ' Rest xmlSearch to the root of the XML tree to be searched.
    Debug.Print i; ": "; xmlSearch.Content
    Set pTemp = afterPtr
    Set afterPtr = xmlSearch
    pTemp.GetRoot2 
    Set xmlSearch = pTemp
Loop

Debug.Print "----"

' A better way:
Dim sbState As Chilkat.StringBuilder
Set sbState = Chilkat.NewStringBuilder
i = 0
Do While xml.NextInTraversal2(sbState) <> False
    If (xml.TagEquals("testchild1") = True) Then
        Debug.Print i; ": "; xml.Content
        i = i + 1
    End If

Loop
xml.GetRoot2