Need to help to read a XML file

[usubrama]

Hi ,

I have attached a file with this post . It is a XMl file

At the end of the file the folliwing snippet will be seen
<ns1:Value><ns1:GroupId>165582</ns1:GroupId><ns1:Status>SUCCESS</ns1:Status></ns1:Value></ns2:result>

I need to use vb script to get the value of group id.
I have used the syntax below.
oDoc.load(sReturnXml)
oNode = oDoc.getElementsByTagName("ns1:GroupId")
sGroupId = oNode.Text

But I cannot get the groupid value. Please help. Thank you

[gmayor]

If you open the document in Word it will translate the xml and you could use VBA to get the value that you want e.g.

Sub Macro1()
Dim oRng As Range
Dim lngPara As Long
    For lngPara = ActiveDocument.Paragraphs.Count To 1 Step -1
        Set oRng = ActiveDocument.Paragraphs(lngPara).Range
        oRng.End = oRng.End - 1
        If IsNumeric(Trim(oRng.Text)) = True Then
            MsgBox oRng.Text
            Exit For
        End If
    Next lngPara
    Set oRng = Nothing
End Sub