VBA Loop Through XML Nodes Using SelectSingleNode

Question

I am trying to update node values in a .xml file using a loop.

The oXMlFile.SelectSingleNode 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.

Any help would be appreciated.

Set oXMLFile = CreateObject("Microsoft.XMLDOM")
oXMLFile.Load (ConfigFile)

'Update Node Attributes

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

 Do While (ii < TotCh - 1)


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

CalibrationDateTimeNode.Text = "2016-04-16"

 ii = ii + 1
 Loop

vacip · Accepted Answer · 2016-04-16 00:17:44Z

1

I'm not quite sure what you exactly need, but to loop through xml nodes, use this:

Dim calibrationDateTimeNode As IXMLDOMNode
Dim colNodes As IXMLDOMNodeList

Set colNodes = oXMLFile.selectNodes("/HConfig/Signal[0]/...WhateverYouNeed")
For Each CalibrationDateTimeNode In colNodes
   CalibrationDateTimeNode.Text = "2016-04-16"
Next

The SelectNodes command can selet a node list, and then you can iterate its elements. Using a for each makes it a lot easier than a do-while. Not to mention faster, if I'm not mistaken.

answered Apr 16, 2016 at 0:17

vacip

5,4563 gold badges29 silver badges56 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

jmjaeckels Over a year ago

Thanks, that is what I needed and everything works now.

Collectives™ on Stack Overflow

VBA Loop Through XML Nodes Using SelectSingleNode

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related