(Excel) AddAttribute - Insert New Attribute in an XML Node

Demonstrates adding an name=value attribute to an XML element.

This example uses the XML sample file here: sample1.xml. The sample1.xml file contains this content:

Download Excel Class Modules Chilkat Excel Class Modules

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


success = xml.LoadXmlFile("qa_data/xml/sample1.xml")
If (success <> True) Then
    Debug.Print xml.LastErrorText
    Exit Sub
End If

' Navigate to the "books" element:

bFound = xml.FindChild2("books")
If (bFound = False) Then
    Debug.Print "No books child found!"
    Exit Sub
End If


numChildren = xml.NumChildren


i = 0
Do While i < numChildren

    ' Navigate to the Nth book 
    Dim success As Boolean
    success = xml.GetChild2(i)

    ' Display the book title:
    Debug.Print xml.GetAttrValue("title")

    ' Add a new integer attribute:
    ' Should never fail..
    success = xml.AddAttributeInt("bookId",i)

    ' Add a new unread="yes" attribute:
    success = xml.AddAttribute("unread","yes")

    ' Navigate back up to the parent:
    success = xml.GetParent2()

    i = i + 1
Loop

' Navigate back to the document root:
xml.GetRoot2 

' Save the updated document:
success = xml.SaveXml("modified.xml")
If (success <> True) Then
    Debug.Print xml.LastErrorText
    Exit Sub
End If

Debug.Print xml.GetXml()