I am using XmlHttp object in my DTS script. Lets assume that I am hitting a URL and capturing the html source of that site to a variable. [Till this part I have done]. I need to know how to save the responseText as an excel worksheet?

For testing it easily I am testing using a simple HTML page with vbscript (which is given below)

Source code:

Function ScreenScrapping()
  URL == "UR site URL comes here"
  objXmlHttp.Open "POST", url, False
  objXmlHttp.onreadystatechange = getref("HandleStateChange")
  objXmlHttp.Send
End Function

Function HandleStateChange()
  If (ObjXmlHttp.readyState = 4) Then
    msgbox "Screenscrapping completed .."
    divShowContent.innerHtml = objXmlHttp.responseText
  End If
End Function

On click of a button i would call the method ScreenScrapping().

Btw, if at all I am posting this in a wrong area .. pls do let me know.

Best Regards
Vadivel

http://vadivel.blogspot.com