VBA Loop Through XML Nodes Using SelectSingleNode
<p>I am trying to update node values in a .xml file using a loop. </p>

<p>The <code>oXMlFile.SelectSingleNode</code> line shown correctly updates a single node, but I don't know how to modify the code so that I can loop though all the nodes and update the values. </p>

<p>Any help would be appreciated.</p>

<pre><code>Set oXMLFile = CreateObject("Microsoft.XMLDOM")
oXMLFile.Load (ConfigFile)

'Update Node Attributes

Dim ii, TotChan As String
 ii = 0
 TotCh = 500

 Do While (ii &lt; TotCh - 1)


Set CalibrationDateTimeNode=oXMLFile.SelectSingleNode("/HConfig/Signal[0]/CalibrationDateTime")

CalibrationDateTimeNode.Text = "2016-04-16"

 ii = ii + 1
 Loop
</code></pre>