Query while Importing web page table
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 |
Query while Importing web page table
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 |
Query while Importing web page table
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 |
All times are GMT +1. The time now is 08:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com