Hi there,

I have some web querys running (which download stock prices from yahoo
finance). THese are set to update every few minutes (via the
refreshperiod property).

I'd like to be able to keep historical records of everything that is
downloaded with each webquery. I fugre that the best way of doing this
is to copy the results of each query into a separate table.

Which brings me to my question... Is there any way to get a piece of
code to execute immediately after vba / excel has performed one of
it's web query refreshes? I imagine the other way is to have a loop
which just copies all the results every few minutes, but this seems a
bit hit and miss to me (and will pbly stop vba doing anything else
useful in the meantime).

Many thanks,

Chris