(Excel) RemoveChild using a Tag Path

Demonstrates calling RemoveChild 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|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>
' 	                <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.RemoveChild "north_america|united_states|california"

Debug.Print xml.GetXml()

' xml now contains:

' 	<?xml version="1.0" encoding="utf-8" ?>
' 	<world>
' 	    <north_america>
' 	        <united_states>
' 	            <illinois>
' 	                <chicago>Windy City</chicago>
' 	            </illinois>
' 	        </united_states>
' 	    </north_america>
' 	</world>