Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Refreshing - values
Can this procedure be run in the background so that it does not bog down the
system? Thanks "Matt Lawson" wrote: I am using a web query to retreive data from a webpage. This data needs to be constantly updated, and there is an option for this. However, the filename changes every hour. I can generate a filename based on the current time (using the =NOW() command). I recorded a macro setting up the web query and found I could make it part of a macro also (that is, input the filename as a variable.) However, the real problem I just discovered is as such: How do I refresh the =now() statement every 5 minutes or so, that way the correct file names can be generated? Any ideas? Thanks Matt Lawson Thanks, Matt Lawson |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Refreshing - values
Hi
this is what OnTime would do -- Regards Frank Kabel Frankfurt, Germany "Matt Lawson" schrieb im Newsbeitrag ... Can this procedure be run in the background so that it does not bog down the system? Thanks "Matt Lawson" wrote: I am using a web query to retreive data from a webpage. This data needs to be constantly updated, and there is an option for this. However, the filename changes every hour. I can generate a filename based on the current time (using the =NOW() command). I recorded a macro setting up the web query and found I could make it part of a macro also (that is, input the filename as a variable.) However, the real problem I just discovered is as such: How do I refresh the =now() statement every 5 minutes or so, that way the correct file names can be generated? Any ideas? Thanks Matt Lawson Thanks, Matt Lawson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Function Values Not Refreshing | Excel Worksheet Functions | |||
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) | |||
Refreshing drop down cell values... | Excel Worksheet Functions | |||
Auto Refreshing: data retreival from webpage | Excel Programming |