Excel webquery questions
From: GF (grams.home_at_home.nl)
Date: 01/18/05
- Next message: Bill Kuunders: "Re: Macro Warning, But No Macros!"
- Previous message: John Schneider: "Macro Warning, But No Macros!"
- Next in thread: Don Guillett: "Re: Excel webquery questions"
- Reply: Don Guillett: "Re: Excel webquery questions"
- Messages sorted by: [ date ] [ thread ]
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.
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.
- Next message: Bill Kuunders: "Re: Macro Warning, But No Macros!"
- Previous message: John Schneider: "Macro Warning, But No Macros!"
- Next in thread: Don Guillett: "Re: Excel webquery questions"
- Reply: Don Guillett: "Re: Excel webquery questions"
- Messages sorted by: [ date ] [ thread ]