Simple question: How to get web query to NOT overwrite data when it refreshes?
4 réponses
salmanrushdie
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.
Cette action est irreversible, confirmez la suppression du commentaire ?
Signaler le commentaire
Veuillez sélectionner un problème
Nudité
Violence
Harcèlement
Fraude
Vente illégale
Discours haineux
Terrorisme
Autre
Philippe.R
Bonsoir A Smith, Beaucoup de choses concernant ces problématiques sur le site : 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 news:
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" <salmanrushdie@gmail.com> a écrit dans le message de
news:8f18145d.0409051307.dc77d4b@posting.google.com...
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 : 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 news:
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.
Clément Marcotte
Ça commence bien
"A Smith" a écrit dans le message de news:
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" <salmanrushdie@gmail.com> a écrit dans le message de
news:8f18145d.0409051307.dc77d4b@posting.google.com...
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.
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.
Daniel.M
"Clément Marcotte" wrote in message news:
Ça commence bien
:-)
Ben quoi Clément: faut bien qu'il te teste un peu! ;-)
Salutations,
Daniel M. (qui n'a jamais bien compris la stratégie d'un 'crosspost' unilingue dans des groupes de discussion ne partageant pas la même langue)
"Clément Marcotte" <clement.marcotte@sympatico.ca> wrote in message
news:ezZ9LG8kEHA.208@TK2MSFTNGP12.phx.gbl...
Ça commence bien
:-)
Ben quoi Clément: faut bien qu'il te teste un peu! ;-)
Salutations,
Daniel M. (qui n'a jamais bien compris la stratégie d'un 'crosspost' unilingue
dans des groupes de discussion ne partageant pas la même langue)
Ben quoi Clément: faut bien qu'il te teste un peu! ;-)
Salutations,
Daniel M. (qui n'a jamais bien compris la stratégie d'un 'crosspost' unilingue dans des groupes de discussion ne partageant pas la même langue)
;o))) Bonjour Clément !!!
Quossé ça ??? A peine arvenu, commence déja à pogner les nerfs .... Pête pas ta chaine, prends ton gaz égal !!!! tu taponnes à répondre à ces morons ....
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.
.
;o)))
Bonjour Clément !!!
Quossé ça ???
A peine arvenu, commence déja à pogner les nerfs ....
Pête pas ta chaine, prends ton gaz égal !!!!
tu taponnes à répondre à ces morons ....
Quossé ça ??? A peine arvenu, commence déja à pogner les nerfs .... Pête pas ta chaine, prends ton gaz égal !!!! tu taponnes à répondre à ces morons ....