(Excel) Find Direct Child with Specific Tag

Demonstrates how to find a direct child having a specific tag.

The input XML, available at http://www.chilkatsoft.com/data/fruit.xml, is this:

<root>
    <fruit color="red">apple</fruit>
    <fruit color="green">pear</fruit>
    <veg color="orange">carrot</veg>
    <meat animal="cow">beef</meat>
    <xyz>
        <fruit color="blue">blueberry</fruit>
        <veg color="green">broccoli</veg>
    </xyz>
    <fruit color="purple">grape</fruit>
    <cheese color="yellow">cheddar</cheese>
</root>

Download Excel Class Modules Chilkat Excel Class Modules

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

' The sample input XML is available at http://www.chilkatsoft.com/data/fruit.xml

success = xml.LoadXmlFile("qa_data/xml/fruit.xml")
If (success <> True) Then
    Debug.Print xml.LastErrorText
    Exit Sub
End If

' Find the direct child node having the tag "meat", and 
' return a new instance of the XML object referencing the
' child node, if found.

Set child = xml.FindChild("meat")
If (xml.LastMethodSuccess = False) Then
    Debug.Print "No direct child having the tag ""meat"" was found."
Else
    Debug.Print "Content = "; child.Content

End If

' The same can be accomplished without creating a new 
' XML object instance.  Instead, the FindChild2 method updates
' the caller's internal reference to the found child, if successful.
success = xml.FindChild2("meat")
If (success = True) Then
    ' Success!  The xml object now references the found child.
    Debug.Print "Content = "; xml.Content
    ' Restore the reference back to the parent.
    success = xml.GetParent2()
Else
    Debug.Print "No direct child having the tag ""meat"" was found."
End If