Re: Excel webquery questions

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Don Guillett (donaldb_at_281.com)
Date: 01/18/05 

Date: Tue, 18 Jan 2005 14:16:43 -0600

I did not find that the url returned the same one at the top as you show...
But, you import and then use a macro or a formula using INDIRECT to fetch
the value needed to another ***. You can use FIND within a macro.

You shouldn't need 500 separate urls. Just a list of the common denominators
and a macro to loop through the list>get the data> and then get the next one
to go next to the one on your list. 

-- 
Don Guillett
SalesAid Software
donaldb@281.com
"GF" <grams.home@home.nl> wrote in message
news:3555nhF4f1gpmU1@individual.net...
> I have about 500 URL's, which I want to use in webqueries.
> I have two problems.
>
> PROBLEM 1
> ^^^^^^^^^
>
> Every URL returns a page with tables, and I know which table I need (for
> every page the same table)
>
> As an example, this is one of the URLS's.
>
>
http://www.realestate.com.au/cgi-bin/rsearch?a=s&cu=&s=wa&ag=&t=res&snf=ras&pm=&tb=&u=FURNISSDALE&px=&cat=&minlandsize=&minbed=4&maxbed=&parking=&p=10&o=p
>
> I need the cel, displaying the first offer.
> This webquery works, and returns:
>
> ----------
>
> GREENFIELDSThe Real Mccoy
> $195,000
> 4 bedroom House
> Located in the suburb of Greenfields. Close to the future train station,
the
> bus station and the Greenfields Shopping center. This home has a lot of
> promises. It features four bedrooms, two bathrooms, lounge and family
> area...
> New ReleaseStreet Map property details>>
>
> ----------
>
>
> I only need the cell displaying the price $ 195,000
> Is it possible, to import only that value to a certain cel in my
excel***,
> not the rest?
> The value I need appears in B2, when I let the query run in A1.
>
> I have 600 queries, from which I need to get only that first value (in
this
> case $ 195,000) in a column.
>
>
>
> PROBLEM 2
> ^^^^^^^^^
>
> I have a list of all the (600) URL's I need for all my queries, is it
> possible to import those in one go, or is it possible to automaticly
create
> all the queries, when I provide the list of URL's?
>
> Thanks for your help,
> G.
>
>
Quantcast