I was trying to use a MSXML2.DOMDocument to extract data I need from an XML response to a SOAP call. The return data looks something like

<?xml version="1.0" encoding="utf-8"?><soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<soap:Body>
<ExecuteDataSourceResponse xmlns="http://www.plexus-online.com/DataSource">
<ExecuteDataSourceResult>
<StatusNo>0</StatusNo>
<Error>false</Error>
<ErrorNo>0</ErrorNo>
<Message>Success</Message>
<InstanceNo>219</InstanceNo>
<DataSourceKey>65299</DataSourceKey>
<QuarantinedForDevelopment xsi:nil="true" />
<LastPrimaryDeployment xsi:nil="true" />
<LastTestDeployment xsi:nil="true" />
<Version xsi:nil="true" />
<DataSourceName>sproc283025_Recipe_Dip_Spin_Get</DataSourceName>
<ResultSets>
<ResultSet>
<RowCount>2</RowCount>
<Rows>
<Row>
<Columns>
<Column>
<Value>DIP/SPIN LINE 21</Value>
<Name>Str_Production_Line</Name>
</Column>
<Column>
<Value>0</Value>
<Name>Int_Angle_Of_Tilt</Name>
</Column>
<Column>
<Value>DGZ 0000 - 1</Value>
<Name>Intpk_Part_Step_Ds_Id</Name>
</Column>
<Column>
<Value>6828526</Value>
<Name>Intpk_Part_Step_Id</Name>
</Column>
<Column>
</Columns>
</Row>
<Row>
<Columns>
<Column>
<Value>DIP/SPIN LINE 22</Value>
<Name>Str_Production_Line</Name>
</Column>
<Column>
<Value>20</Value>
<Name>Int_Angle_Of_Tilt</Name>
</Column>
<Column>
<Value>DGZ 0000 - 1</Value>
<Name>Intpk_Part_Step_Ds_Id</Name>
</Column>
<Column>
<Value>6828528</Value>
<Name>Intpk_Part_Step_Id</Name>
</Column>
</Columns>
</Row>
</Rows>
</ResultSet>
</ResultSets>
</ExecuteDataSourceResult>
</ExecuteDataSourceResponse>
</soap:Body>
</soap:Envelope>


I'm trying to access specific values but am not sure how to specify a particular row. My original attempt was -

Code:
Dim doc As New MSXML2.DOMDocument
    
   Dim success As Boolean

   success = doc.loadXML(txtResponse.Text)
   
   If success = False Then
      MsgBox doc.parseError.reason
   Else
        MsgBox "Str_Production_Line = " & doc.selectSingleNode("//Column[Name='Str_Production_Line']/Value").nodeTypedValue
   End If
This returns the first value but I don't know how to modify it to loop through each row and get the value.