Using XML in VBA

Introduction

Dynamic RibbonX controls are both

• Serializable to XML
• Instantiatable from XML

Serializing to XML

Public Sub SerializingButton()
 
    ' Create a new button
    Dim myButton As rxButton
    Set myButton = New rxButton
 
    ' Build up state
    With myButton
        .label = "My Button"
        .enabled = rxTrue
        .supertip = "My button supertip"
 
        ' Serialize to XML
        Debug.Print .XML
    End With
 
End Sub

The VBA code above prints out the following XML code to the debug window:

<button supertip="My button supertip" enabled="true" label="My Button"></button>

Instantiating from XML

1. Public Sub InstantiateButtonFromXML()

3.     ' Create a new button

4.     Dim myButton As rxButton

5.     Set myButton = New rxButton

7.     myButton.readXml "<button supertip=""My button supertip"" enabled=""true"" label=""My Button""/>"

9.     Debug.Print "supertip=[" & myButton.supertip & "], enabled=[" & myButton.Enabled & "], label=[" & myButton.Label & "]"

11. End Sub

The VBA code above prints out the following XML code to the debug window:

supertip=[My button supertip], enabled=[-1], label=[My Button]