| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I save external data in Excel?
I use 'Get External Data' 'From Web' to pull an HTML table of single row from
a website into my Excel file. In 'External Data Range Properties' in 'Refresh Control' I have set it to 'Refresh every "1" minutes'. I wish to save new data from the sever in every refresh in my Excel file, one row above the previous so that the latest data arrives in the top row and the previous data is pushed down. What is the best way for doing this? Is there a way I can trigger a macro on every refresh? Thanks in advance! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I save external data in Excel? | Excel Discussion (Misc queries) | |||
| Save Excel without formula drawing from external data | Excel Discussion (Misc queries) | |||
| Cannot save external data into file excel system show not respondi | Excel Discussion (Misc queries) | |||
| External Data Refresh on save problem | Excel Discussion (Misc queries) | |||
| Don't save external data. | Excel Programming | |||
![Ankur Bhatnagar[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
