How do you use the SOAP response from Web Service

See more:

VB

XML

MS-Excel

web

SOAP

I need help in using the SOAP Response.

I need to create a live feed which refreshes every 10sec.

I can pull the response into a string But i need to apply the response to cells on an excel spreadsheet using VS to create.


Any help would be great
Thanks

Dim key As String
       Dim j As String
       Dim rt As String
       Dim racing As New au.com.tab.racing.Racing
       Dim meetings As Object

       Dim data As String


       Button3.Visible = True
       Button4.Visible = False

       key = Range("B4").Value
       j = Range("B9").Value
       If Range("B8").Value = "Races" Then
           rt = "r"
       ElseIf Range("B8").Value = "Harness" Then
           rt = "h"
       ElseIf Range("B8").Value = "Greyhounds" Then
           rt = "g"
       End If

       meetings = racing.NextEvent(key, j, rt)



       data = CType(meetings, System.Xml.XmlElement).InnerXml


       Range("A20").Value = data
       data = DirectCast(DirectCast(meetings, System.Xml.XmlElement).FirstChild, System.Xml.XmlElement).InnerXml
       Range("A21").Value = data
       data = DirectCast(DirectCast(DirectCast(meetings, System.Xml.XmlElement).FirstChild, System.Xml.XmlElement).FirstChild, System.Xml.XmlElement).InnerXml
       Range("A22").Value = data
       data = DirectCast(DirectCast(DirectCast(meetings, System.Xml.XmlElement)., System.Xml.XmlElement).FirstChild, System.Xml.XmlElement).InnerXml
       Range("A23").Value = data