Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Refreshing: data retreival from webpage
My question is as such:
I have a small excel program that retreives data from a webpage; this data is updated every 5 minutes and it is essential that the operator of this excel file sees the updated data at all times. Currently I have implemented a button that they can click to update to refresh the data; however, it would be much better if there was a way to have excel automatically refresh the data (ie. retreive it from the webpage again) at a certain interval (say 5 minutes.) Thanks in advance, Matt Lawson |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Refreshing: data retreival from webpage
Hi Matt,
Are you using a Web Query to retrieve the data? menu Data Import (or Get) External Data. If so, right click on the returned data from the first run and choose Data Range Properties. There, you can check the boxes to have the query automatically refreshed when book opens, every x minutes, .... If not, can you make it a web query? Regards, Sebastien "Matt Lawson" wrote: My question is as such: I have a small excel program that retreives data from a webpage; this data is updated every 5 minutes and it is essential that the operator of this excel file sees the updated data at all times. Currently I have implemented a button that they can click to update to refresh the data; however, it would be much better if there was a way to have excel automatically refresh the data (ie. retreive it from the webpage again) at a certain interval (say 5 minutes.) Thanks in advance, Matt Lawson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Refreshing: data retreival from webpage
Yes, I am using a webquery.
However, the real problem I just discovered is as such: The filename of the webpage that contains the data is constantly changing (changes every day and hour) Now, I can generate this file name to input based on the data, HOWEVER. I am using the =NOW() statement to determine the date and then extract the corresponding filename. However, I have no way of refreshing the NOW statement automatically besides having the user hit a refresh button of some sort. Any ideas? Thanks, Matt Lawson "sebastienm" wrote: Hi Matt, Are you using a Web Query to retrieve the data? menu Data Import (or Get) External Data. If so, right click on the returned data from the first run and choose Data Range Properties. There, you can check the boxes to have the query automatically refreshed when book opens, every x minutes, .... If not, can you make it a web query? Regards, Sebastien "Matt Lawson" wrote: My question is as such: I have a small excel program that retreives data from a webpage; this data is updated every 5 minutes and it is essential that the operator of this excel file sees the updated data at all times. Currently I have implemented a button that they can click to update to refresh the data; however, it would be much better if there was a way to have excel automatically refresh the data (ie. retreive it from the webpage again) at a certain interval (say 5 minutes.) Thanks in advance, Matt Lawson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving data to a webpage | New Users to Excel | |||
Simple MS Query with Data Parameters Not Auto-refreshing | Excel Discussion (Misc queries) | |||
Auto refreshing and printing a form with data from each row of a spreadsheet | Excel Discussion (Misc queries) | |||
Linking Webpage to Excel Data | Excel Worksheet Functions | |||
How to retrieve and write data to a webpage | Excel Programming |