Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |