Script to read a XML file

[Anand]

Hi all,

I am new to VBScripting. i want to read XML file to itereate through all tag names, Tag Values,Attribute Names and Attribute Value.

I have attached the sample XML

Please anyone can help me with the code.

Regards,
Anand

[suresh vasu]

Anand,

Please go through the below link, hopefully that will solve your problem.

http://motevich.blogspot.com/2008/09/how...tp_08.html

[deepaksporty]

Hi Anand,

Please go through XMLDOM Object model...you can google it "vbscript+XMLDOM" and go through the methods and properties which XML DOM provides. You'll also get some examples/sample code which'll help you to better understand the concept.

[Anand]

I got the code for retriving node values but i was not able to find the code for retriving attribute value.

i want to get the value of attribute "ref" in the below xml:
---------------------------------------------

Code:

<States>
   <State ref="FL">
      <name>Florida</name>
      <capital>Tallahassee</capital>
   </State>
   <State ref="IA">
      <name>Iowa</name>
      <capital>Des Moines</capital>
   </State>
</States>

VBScript:

Code:

Set objXMLDoc = CreateObject("Microsoft.XMLDOM")
objXMLDoc.async = False
objXMLDoc.load("states.xml")

Dim objChildNodes, strNode
Set objChildNodes = objXMLDoc.documentElement.childNodes<State>

For Each strNode In objChildNodes
   document.write(strNode.nodeName & "<br>")
Next

[Anand]

@suresh vasu : The link provided by you also doesnt gives info of how to get the values of attribute