(Excel) Benefit of XML Methods Having Names Ending in "2"

The Chilkat XML methods having names ending with "2" update the internal reference rather than return a new XML object instance. See the example below..

Note: There are a few methods, such as LoadXml2, where the "2" simply indicates the method is the same but has an additional argument. (There are some programming environments where overloading methods is not allowed. Therefore, Chilkat will avoid providing methods having the same name but with different arguments.)

Download Excel Class Modules Chilkat Excel Class Modules

x = "<test><abc><xyz>123</xyz></abc></test>"

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


success = xml.LoadXml(x)

' First demonstrate getting "123" in the simplest way:
Debug.Print xml.ChilkatPath("abc|xyz|*")

' Now demonstrate navigating to the "xyz" node using non-"2" methods.
' The following few lines of code create two object instances, which will need
' to be deleted or garbage collected.

Set xAbc = xml.FindChild("abc")

Set xXyz = xAbc.FindChild("xyz")
Debug.Print xXyz.Content

' Now demonstrate navigating to the "xyz" node using the "2" methods.
' No object instances are created.
success = xml.FindChild2("abc")
success = xml.FindChild2("xyz")
Debug.Print xml.Content
' Restore xml back to the root of the document.
xml.GetRoot2