View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
andrewman andrewman is offline
external usenet poster
 
Posts: 1
Default Web Query, Help!

I'm currently trying to create an excel sheet that will record the
internet bandwidth from a website (http://reviews.cnet.com/
7004-7254_7-0.html) every 15 minutes until I save and close the
document. I have tried web queries, using the below code:

WEB
1
http://reviews.cnet.com/7018-7254_7-0.html?start=1&ac=["AreaCode","Enter
Area Code"]&CType=5732&ISPID=&ISPNAME=&submit=Go

Selection=false
Formatting=All
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False
DisableDateRecognition=TRUE
DisableRedirections=FALSE


The problem is that the data returned from the site is actually the
URL itself, ie http://reviews.cnet.com/7009-7254_7-...&kbps=389 6.8
for area code 615. My dilemma is that I do not know how to read the
address/URL to which I was redirected (I receive an error message that
says "This web query returned no data....").

It is important that I use the bandwidth test through this specific
website, so I'm in a real pickle.


Please help!