use MSXML2.ServerXMLHTTP to get an excel file

[jadec]

Hi,

I try to use MSXML2.ServerXMLHTTP to get an excel file and display on line, I got error on the last line:
response.write httpdoc.responseText

Please see the following code:

queryString = "[URL unfurl="true"]http://myipaddress/reports/WRP0553.XLS"[/URL]
  Dim httpdoc
  Set httpdoc = Server.CreateObject("MSXML2.ServerXMLHTTP")
  httpdoc.Open "GET", queryString, False
  httpdoc.Send
  Response.ContentType = "application/vnd.ms-excel"
  response.write httpdoc.responseText

Please help !!!
Thanks a lot ahead !!!

 

[damber]

maybe if you tell us what the error says, we might be able to help you..

A smile is worth a thousand kind words. So smile, it's easy!