Web Query - No data
 

Hi all

I'm experiencing some problems with a web query I wrote a few days ago

We have a website that generates reports and the url of my web query point
to an asp page in this website. The problem is that sometimes it works and sometime
it doesn't. The query has never changed and I can't understand why it doesn't work all the time??
When it doesn't work, you can go to Internet exporer and type the url that failed in the web query and the website will serve you the page as expected

Has anyone experience a problem like this
Any hints as to what might be causing the problems

Below you can see my code

strQuery = "URL;" & strLocation &
"?txtID=" & CStr(lngReportID) &
"&txtFromDate=" & Format$(dtmFromDate, "dd/mm/yyyy") &
"&txtToDate=" & Format$(dtmToDate, "dd/mm/yyyy"

' objWs is a worsheet objec
' objQTB is a query table objec
Set objQTB = objWS.QueryTables.Add(Connection:=strQuery, Destination:=Range("A1")

The above is the line where it fails

Error message
The remote server machine does not exist or is unavailabl

However if I copy the url from the query string and past it into Internet explorer it works just fine..

Yago