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?
--
Vicky

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

Tim


"Vicky" wrote in message
...
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?
--
Vicky

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!
--
Vicky


"Vicky" wrote:

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?
--
Vicky

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

--
Don Guillett
SalesAid Software

"Vicky" wrote in message
...
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!
--
Vicky


"Vicky" wrote:

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?
--
Vicky