(Excel) Create XML using Tag Paths

Demonstrates creating an XML document using tag paths.

This example requires Chilkat v9.5.0.64 or greater.

Download Excel Class Modules Chilkat Excel Class Modules

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

xml.Tag = "world"

' This example uses features introduced in v9.5.0.64
xml.NewChild2 "north_america|united_states|california|sacremento","capital"
xml.NewChild2 "north_america|united_states|california|los_angeles","City of Angels"
xml.NewChild2 "north_america|united_states|california|san_francisco","Silicon Valley"
xml.NewChild2 "north_america|united_states|california|san_diego","Birthplace of California"
xml.NewChild2 "north_america|united_states|illinois|chicago","Windy City"

Debug.Print xml.GetXml()

' Produces the following XML
' 
' 	<?xml version="1.0" encoding="utf-8" ?>
' 	<world>
' 	    <north_america>
' 	        <united_states>
' 	            <california>
' 	                <sacremento>capital</sacremento>
' 	                <los_angeles>City of Angels</los_angeles>
' 	                <san_francisco>Silicon Valley</san_francisco>
' 	                <san_diego>Birthplace of California</san_diego>
' 	            </california>
' 	            <illinois>
' 	                <chicago>Windy City</chicago>
' 	            </illinois>
' 	        </united_states>
' 	    </north_america>
' 	</world>
'