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 |
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 |