(Excel) XML NewChild2 using a Tag Path

Demonstrates the XML NewChild2 method using a tag path.

Note: This example requires Chilkat v9.5.0.64 or later.

Download Excel Class Modules Chilkat Excel Class Modules

' Note: This example requires Chilkat v9.5.0.64 or later.
Dim xml As Chilkat.Xml
Set xml = Chilkat.NewXml

xml.Tag = "aaa"

' A single tag can be passed to NewChild2, and this behaves as it always has:
xml.NewChild2 "penguin","flightless bird"
xml.NewChild2 "mammal",""
Debug.Print xml.GetXml()

' The output:

' 	<?xml version="1.0" encoding="utf-8" ?>
' 	<aaa>
' 	    <penguin>flightless bird</penguin>
' 	    <mammal />
' 	</aaa>
' 
' Starting in v9.5.0.64, a tag path can be used.
' It will cause nodes to be automatically created as needed.
xml.NewChild2 "red|green|blue","sky"
xml.NewChild2 "mammal|rodent|squirrel","bushy tail"
Debug.Print xml.GetXml()

' The output:

' 	<?xml version="1.0" encoding="utf-8" ?>
' 	<aaa>
' 	    <penguin>flightless bird</penguin>
' 	    <mammal>
' 	        <rodent>
' 	            <squirrel>bushy tail</squirrel>
' 	        </rodent>
' 	    </mammal>
' 	    <red>
' 	        <green>
' 	            <blue>sky</blue>
' 	        </green>
' 	    </red>
' 	</aaa>
'