I have a similar questions posted, but I need to clarify and start again.
Basically I have data in XML format as a DOM Document in memory in my VBA program.
Dim xmlResponseDoc As New DOMDocument40
Dim xmlJobResponse As IXMLDOMNode
Dim xmlJobQueryNode As IXMLDOMNode
Dim xmlFilterNode As IXMLDOMNode
Dim xmlNodeList As IXMLDOMNodeList
Here's the XML data in memory as xmlJobResponse:
<JobQueryRs ErrorCode="0" Message="">
.... above is "header" information for a single Job. now is where the question is. A job can have many <RoutingLine> sections similar to below.
<WorkCenteRef ID="90 PRESS"/>
I need to be able to select into memory the RoutingLine.ID(1824 or 1825) based off of the WorkCenterRef ID attribute!
So basically I need to query all routing line sections in this XML Document in memory and select by WorkCenterRef ID ="specified value" and then store the ID from that RoutingLine section.
search for WorkCenterRef ID="Lathe" and return the ID value of 1825
I Know how to selectSingleNode, but I don't know how to return a NodeList or section of an XML document and then access node values in that "section" for my one to many scenario.