Difference between revisions of "Using XML in VBA"

Revision as of 23:05, 14 March 2013

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

```
Public Sub InstantiateButtonFromXML()
```
```
 
```
```
    ' Create a new button
```
```
    Dim myButton As rxButton
```
```
    Set myButton = New rxButton
```
```
 
```

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

```
 
```

    Debug.Print "supertip=[" & myButton.supertip & "], " & _

                "enabled=[" & (myButton.Enabled = rxTrue) & "], " & _

                "label=[" & myButton.Label & "]"

```
 
```
```
End Sub
```

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

supertip=[My button supertip], enabled=[True], label=[My Button]

Difference between revisions of "Using XML in VBA"

Revision as of 23:05, 14 March 2013

Introduction

Serializing to XML

Instantiating from XML

Navigation menu

Personal tools

Namespaces

Variants

Views

More

Search

Navigation

Tools