(Excel) UpdateChildContent using a Tag Path

Demonstrates updating the content of a node using UpdateChildContent with a tag path.

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>
' 

xml.UpdateChildContent "north_america|united_states|california|san_diego","Mild Climate"

' An alternative way of doing it:
Dim success As Boolean
success = xml.FindChild2("north_america|united_states|california")
xml.UpdateChildContent "san_francisco","Golden Gate Bridge"
xml.GetRoot2 

Debug.Print xml.GetXml()

' The XML now contains:

' 	<?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>Golden Gate Bridge</san_francisco>
' 	                <san_diego>Mild Climate</san_diego>
' 	            </california>
' 	            <illinois>
' 	                <chicago>Windy City</chicago>
' 	            </illinois>
' 	        </united_states>
' 	    </north_america>
' 	</world>