Hello,

I am importing stock information with a webquery into excel.


But the imported data is now overwritten every minute.
Is it possible to save the data so I get a nice row of imported data per minute ?

Thanks.

Yannick

Hi Yannick

In the module where the Web Query code is have a look for something like this
If it's the same, change it to False. When set to False, the code waits for the data to be imported before it proceeds, you can then add some code after the refresh code to copy the imported data line to another worksheet