Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert hard coded query criteria to Parameter Query | Excel Discussion (Misc queries) | |||
Excel 2007 / MS Query - editing existing query to another sheet | Excel Discussion (Misc queries) | |||
Microsoft Query rejects "nz" function in Access Query | Excel Discussion (Misc queries) | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
Stop to modify the SQL query manually entered into query ! | Excel Programming |