Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I tried to use VB in Excel 2000-SP3 to do a web query and it wouldn't work
so I tried doing it manually via Data/Get External Data/New Web Query using: Web page address: http://www.reversephonedirectory.com...757%29+8771111 "The entire page", No formatting, range $A$1 I then get the error: "This web query returned no data. ..." despite the fact that the above is a good URL (try it in your web browser) Other URL's like http://news.com work fine. QUESTION: How can I run a web query with the URL given above? MANY thanks for any help. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
I tried this on xl02 and it works fine, I do get a script error when I load the page so that might be the problem Edgar -----Original Message----- I tried to use VB in Excel 2000-SP3 to do a web query and it wouldn't work so I tried doing it manually via Data/Get External Data/New Web Query using: Web page address: http://www.reversephonedirectory.com...ges/phone/inde x.html?number=%28757%29+8771111 "The entire page", No formatting, range $A$1 I then get the error: "This web query returned no data. ..." despite the fact that the above is a good URL (try it in your web browser) Other URL's like http://news.com work fine. QUESTION: How can I run a web query with the URL given above? MANY thanks for any help. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Use MS Query to query data within the current work book | Excel Discussion (Misc queries) | |||
Excel Query Does not Work | New Users to Excel | |||
web query on EXCEL does not work. Why? | Excel Discussion (Misc queries) | |||
web query doesn't work | Excel Discussion (Misc queries) | |||
Web query does not work for USCIS' site | Excel Discussion (Misc queries) |