Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Logging data from a web query
Hi All,
I have set up a web query for a share price and I have 2 questions. Firstly, how can I make Excel update this web query, for example once a minute? Secondly I would like to log some fields (time, shareprice etc) possibly to another sheet every time the data is updated. Can anyone help with this? Thanks in advance, Rob |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Logging data from a web query
I think you will find that if you select all the column
headers of your table then go to 'Data', 'Get External Data', 'Data Range Properties' You will see there is an option to select 'enable background refresh' and choose a time interval ----------------------------------------------------- As for the logging it wouldn't be too hard to create a macro that copied the contents of the table to another workbook to a fresh sheet each time. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use MS Query to query data within the current work book | Excel Discussion (Misc queries) | |||
Logging changes | Excel Discussion (Misc queries) | |||
Save data retreived from query without saving query | Excel Discussion (Misc queries) | |||
DDE Logging Data Loss in Excel | Excel Discussion (Misc queries) | |||
Live DDE Data Logging | Excel Discussion (Misc queries) |