Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc,microsoft.public.fr.excel,microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
IF formula-simple question; simple operator | Excel Discussion (Misc queries) | |||
Simple MS Query with Data Parameters Not Auto-refreshing | Excel Discussion (Misc queries) | |||
"New Web Query" always refreshes data from website (3 times) | Excel Worksheet Functions | |||
Excel link to data in other worksheet only refreshes one column | Excel Discussion (Misc queries) | |||
Combo Box value changing when query refreshes | Excel Programming |