Update a node in xml file

[Mathit]

My sample xml file looks like this:

<Ratings>
<Rating>
<RatingCode>AAA</RatingCode>
<RatingDesc>AAA</RatingDesc>
</Rating>
<Rating>
<RatingCode>BBB</RatingCode>
<RatingDesc>BBB</RatingDesc>
</Rating>
<Rating>
<RatingCode>CCC</RatingCode>
<RatingDesc>CCC</RatingDesc>
</Rating>
</Ratings>

My code looks like this:

Set Doc = Sys.OleObject("Msxml2.DOMDocument.6.0")
Doc.async = False
Call Doc.load(filetoload)
Set Node = Doc.documentElement
Set Nodeval = Doc.selectSingleNode("//Quote/Quotesheets/Ratings/Rating/Ratingcode")
Nodeval.Text = texttoupdate
Call Doc.Save(outputfile1)
Set Doc = Nothing

Is there a way to count the no. of children for Ratings and Rating?

Can you please let me know how I can update the second child of Rating.  ie, i want to update the value BBB to XXX

[AlexKaras]

Hi,

https://stackoverflow.com/questions/7448232/vbscript-select-multiple-xml-nodes-that-use-a-self-closi...

https://docs.microsoft.com/en-us/dotnet/api/system.xml.xmlnode.selectnodes?view=netframework-4.7.2

https://docs.microsoft.com/en-us/previous-versions/windows/desktop/ms754523(v%3Dvs.85)