Friday, September 24, 2010

Reading XML sibling Nodes

Const XMLDataFile = "C:\Documents and Settings\kalyani.g\Desktop\detailedReport.xml"
Set xmlDoc = CreateObject("Microsoft.XMLDOM")
xmlDoc.Async = False
xmlDoc.Load(XMLDataFile)
xmlDoc.SetProperty "SelectionLanguage", "XPath"
Set NodeList = xmlDoc.selectNodes("//Measure[Type='Page data[kB]']")
msgbox(NodeList.Item(0).getAttribute("name"))
msgbox(NodeList.Item(0).getElementsByTagName("Sum")(0).text)

No comments:

Post a Comment