Again with the VBA, working with MSXML2.IXMLDOMNodeList objects. How do you load XML? Well MSDN shows you how to do it from an XML file..
Loading from an XML File:
Dim MyIXMLDOMNodeListVar As MSXML2.IXMLDOMNodeList
Dim xmlDoc As New MSXML2.DOMDocument30
xmlDoc.Load “c:myxml.xml”
If (xmlDoc.parseError.ErrorCode <> 0) Then
Dim myErr
Set myErr = xmlDoc.parseError
MsgBox (“You have error ” & myErr.reason)
Else
Set MyIXMLDOMNodeListVar = xmlDoc.getElementsByTagName(“MyElement”)
End If
Loading from XML string:
Dim MyIXMLDOMNodeListVar As MSXML2.IXMLDOMNodeList
Dim xmlDoc As New MSXML2.DOMDocument30
Dim myXml As String
myXml = “<MyElement>Steve Rules!</MyElement>”
xmlDoc.loadXML (myXml)
If (xmlDoc.parseError.ErrorCode <> 0) Then
Dim myErr
Set myErr = xmlDoc.parseError
MsgBox (“You have error ” & myErr.reason)
Else
Set MyIXMLDOMNodeListVar = xmlDoc.getElementsByTagName(“MyElement”)
End If
You will notice there isn’t much difference, except when you want to load from a string, you use xmlDoc.loadXml instead of just xmlDoc.Load .. I wish I could have found that in the documentation somewhere (maybe it’s there and I just didn’t look hard enough) 🙂