Regardless of how you are running the query (manually or through a macro),
you may change the approach of what data to relocate. Instead of trying to
get the data from the query in a new column, copy the existing data to the
next available column.
You can do it manually once while recording a macro, edit it to assure that
it will do what you expect and use the macro before you run the web query.

Hope this helps,
Miguel.

"samprince" wrote:


I just did a search for new web query and nothing came up so please
don't flame me [=

Excel always comes up with the goods and regulary fulfills the exact
requirement of it you wish for.

I have solved a problem 95% but the final 5% I would like your help on
if possible.

I have an excel document, which I have worked out how to download data
from the internet via a web query every ten minutes. However, when this
refreshes, it overwrites what was collected in the previous ten
minutes.

What I wish to accomplish is for every ten minutes the data to refresh
but 'add the new data' into the next column. This will therefore give
me a large set of data which I can analyse over time.

Any comments, suggestions or the answer to my woes will be much
appreciated.

Many thanks,
SP.


--
samprince
------------------------------------------------------------------------
samprince's Profile: http://www.excelforum.com/member.php...o&userid=34168
View this thread: http://www.excelforum.com/showthread...hreadid=539307