VBA-XMLConverter
Status: Incomplete, Under Development
XML conversion and parsing for VBA (Excel, Access, and other Office applications).
Tested in Windows Excel 2013 and Excel for Mac 2011, but should apply to 2007+.
- For Windows-only support, include a reference to "Microsoft Scripting Runtime"
- For Mac support or to skip adding a reference, include VBA-Dictionary.
Example
Dim XML As Object
Set XML = XMLConverter.ParseXML( _
"<?xml version="1.0"?>" & _
"<messages>" & _
"<message id="1" date="2014-1-1">" & _
"<from><name>Tim Hall</name></from>" & _
"<body>Howdy!</body>" & _
"</message>" & _
"</messages>" _
)
Debug.Print XML("documentElement")("nodeName") ' -> "messages"
Debug.Print XML("documentElement")("childNodes")(1)("attributes")("id") ' -> "1"
Debug.Print XML("documentElement")("childNodes")(1)("childNodes")(2)("text") ' -> "Howdy!"
Debug.Print XMLConverter.ConvertToXML(XML)
' -> "<?xml version="1.0"?><messages>...</messages>"