[RESOLVED] Extracting data from XML

[dlscott56]

Try this:

'-- in Else
        Dim oRow As IXMLDOMNode
        Dim oColumn As IXMLDOMNode
        Dim sRow As String
        For Each oRow In doc.selectNodes("//Rows/Row")
            sRow = vbNullString
            For Each oColumn In oRow.selectNodes("Columns/Column")
                sRow = sRow & oColumn.selectSingleNode("Name").Text & "=" & oColumn.selectSingleNode("Value").Text & vbCrLf
            Next
            MsgBox "sRow=" & sRow, vbExclamation
        Next

cheers,
</wqw>

Perfect! Thanks to all of you for your help with this!