Query while Importing web page table

[Guest]

Dear all,
I've macro codes for web page query table. The webpage table contains the
data for 180 rows & 6 columns. The webpage table overwrites whenever the new
data being updated.
Now i wish to import the data table in excel spreadsheet whithout
overwriting the data tables, although the web page table gets overwrited i.e.
to keep the exsting imported data as it is & import new data below the
exsting datatable or to insert the new rows for new data without overwriting
the exsting data.
Is it possible?
If yes then, how?

 

[Tim Williams]

Why not copy the existing data and append it to another sheet before
refreshing the query?

Tim

 

[Guest]

Thanks Tim,
Copy & paste is possible, but i used to refresh the query after every 1
minute. & I think, this is the time consuming job. Some automation in this
regard will save lots of time.
There is a List constants of xlInsertEntireRows, but i am not getting the
desired report, may be because of the webpage getting overwited.
Help in this regard will work magestically for me!

 

[Don Guillett]

Instead of setting the query to refresh, use a macro that:
uses ONTIME to get the data
copy/paste to another destination.