Excel webquery questions

From: GF (grams.home_at_home.nl)
Date: 01/18/05


Date: Tue, 18 Jan 2005 20:20:52 +0100

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.