Difference between revisions of "Using XML in VBA"
From Ribbon Commander Documentation
(→Instantiating from XML) |
(→Instantiating from XML) |
||
Line 40: | Line 40: | ||
myButton.readXml "<button supertip=""My button supertip"" enabled=""true"" label=""My Button""/>" | myButton.readXml "<button supertip=""My button supertip"" enabled=""true"" label=""My Button""/>" | ||
− | Debug.Print "supertip=[" & myButton.supertip & "], enabled=[" & (myButton.Enabled = rxTrue) & "], label=[" & myButton.Label & "]" | + | Debug.Print "supertip=[" & myButton.supertip & "], " & _ |
+ | "enabled=[" & (myButton.Enabled = rxTrue) & "], " & _ | ||
+ | "label=[" & myButton.Label & "]" | ||
End Sub | End Sub |
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]