Simple question: How to get web query to NOT overwrite data when it refreshes?

I just figured out how to use web queries and it seems like a very
useful tool. However, I need my web query to update a list that
changes moment-by-moment on a certain website. I can get the query to
run and it collects the data necessary but when I ask it to refresh
after five minutes, it REPLACES (overwrites) the data it collected on
the first go-around.

I would like the web query to collect data, import it into the
spreadsheet, wait five minutes, collect data, import it AT THE BOTTOM
of the list, wait five minutes, collect data, import it AT THE BOTTOM
of the list, etc.

instead of simply overwriting the data it collects each time. Does
anyone know what I'm talking about? I'm sure this is a really simple
question but I searched and tinkered a lot and could not figure out
how to solve this problem.

Bonsoir A Smith,
Beaucoup de choses concernant ces problématiques sur le site J@C :
http://jacxl.free.fr/cours_xl/cadres.html
--
Amicales Salutations
XL 97 / 2000 / 2002
Retirer A_S_ pour répondre en privé.
Préférez suivre facilement sur le forum :
news://msnews.microsoft.com/microsoft.public.fr.excel
(Voulez-vous vous abonner ? - Oui)

"A Smith" a écrit dans le message de
m...
I just figured out how to use web queries and it seems like a very
useful tool. However, I need my web query to update a list that
changes moment-by-moment on a certain website. I can get the query to
run and it collects the data necessary but when I ask it to refresh
after five minutes, it REPLACES (overwrites) the data it collected on
the first go-around.

I would like the web query to collect data, import it into the
spreadsheet, wait five minutes, collect data, import it AT THE BOTTOM
of the list, wait five minutes, collect data, import it AT THE BOTTOM
of the list, etc.

instead of simply overwriting the data it collects each time. Does
anyone know what I'm talking about? I'm sure this is a really simple
question but I searched and tinkered a lot and could not figure out
how to solve this problem.

Ça commence bien

"A Smith" a écrit dans le message de
m...
I just figured out how to use web queries and it seems like a very
useful tool. However, I need my web query to update a list that
changes moment-by-moment on a certain website. I can get the query
to
run and it collects the data necessary but when I ask it to refresh
after five minutes, it REPLACES (overwrites) the data it collected
on
the first go-around.

I would like the web query to collect data, import it into the
spreadsheet, wait five minutes, collect data, import it AT THE
BOTTOM
of the list, wait five minutes, collect data, import it AT THE
BOTTOM
of the list, etc.

instead of simply overwriting the data it collects each time. Does
anyone know what I'm talking about? I'm sure this is a really simple
question but I searched and tinkered a lot and could not figure out
how to solve this problem.

You may get an elegant solutions from an MVP.
But this is what I do.
I copy the data each time in another worksheet using vlookup
function.(I have prepared a code for this)


A Smith wrote in message
m...
I just figured out how to use web queries and it seems like a very
useful tool. However, I need my web query to update a list that
changes moment-by-moment on a certain website. I can get the query to
run and it collects the data necessary but when I ask it to refresh
after five minutes, it REPLACES (overwrites) the data it collected on
the first go-around.

I would like the web query to collect data, import it into the
spreadsheet, wait five minutes, collect data, import it AT THE BOTTOM
of the list, wait five minutes, collect data, import it AT THE BOTTOM
of the list, etc.

instead of simply overwriting the data it collects each time. Does
anyone know what I'm talking about? I'm sure this is a really simple
question but I searched and tinkered a lot and could not figure out
how to solve this problem.