Web Query

A

anthony1957

Hello all
I am new to Web Queries and my vb isn't much good either.
I need to go to a specific page enter a string from a list into the
search box on that web page and download the results into excel. I then
need to go to the next string on the list and so on.
I have managed to create a query that will download the first 10
results.
What I would dearly love to do is get the next results and then load up
the next string.
A tall order but much gratitude to anyone that can help.

Anthony
 
D

Don Guillett

Perhaps you could give us the url and exactly what you want. I do this for
clients all the time where you create a macro with a looping variable to get
web data.
myurl=ddddd" & myvariable & "eeee
 
D

Don Guillett

With xl2002, simply goto the url>enter the postcode>click find a
dentist>right click in the resulting table>export to ms excel>record a
macro>data>edit query>change the end of the url
"URL;http://www.streetmap.co.uk/sl/bdadentistry.srf?id=bdadentistry&range=-10&distance=5&code=tn2"import>stop recording>modify your macro to accept an input box or a cellreference.--Don GuillettSalesAid [email protected]<[email protected]> wrote in messagenews:[email protected]...> Don> The URL is http://www.bda-findadentist.org.uk/. I enter the first part> of a postcode e.g. TN1.> Many thanks for responding.>> Anthony>>>> Don Guillett wrote:>> Perhaps you could give us the url and exactly what you want. I do thisfor>> clients all the time where you create a macro with a looping variable toget>> web data.>> myurl=ddddd" & myvariable & "eeee>>>> -->> Don Guillett>> SalesAid Software>> [email protected]>> <[email protected]> wrote in message>> > Hello all>> > I am new to Web Queries and my vb isn't much good either.>> > I need to go to a specific page enter a string from a list into the>> > search box on that web page and download the results into excel. I then>> > need to go to the next string on the list and so on.>> > I have managed to create a query that will download the first 10>> > results.>> > What I would dearly love to do is get the next results and then load up>> > the next string.>> > A tall order but much gratitude to anyone that can help.>> >>> > Anthony>> >>
 
A

anthony1957

Don
I inadvertently forgot to say that I was using Excel 97.
I however managed to download all the hits for one postcode so now need
to implement your insts on the inputbox/cell reference to create a loop
and therefore complete the task.
Thanks again for your help.

Anthony
 
D

Don Guillett

The kind of web query that I mentioned can be adapted to xl97. You are
invited to send your workbook to my address below along with detailed
instructions and I will see what I can do.
 
Top