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!

Web Query, Help!
 

Hi, in my opinion, you have to use the IE control to navigate to the site and
when it returns the data in the url, you can use the methods of the IE
control to access the url and then you can parse the required data using the
various string functions.

"andrewman" wrote:

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!