Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run a macro continuously
My macro fetches data from a website. I want this macro to get the data
every 30 seconds. So I've inserted a time delay. Here's the code. Start = Timer ' Set start time. Do While Timer < Start + 30 DoEvents ' Yield to other processes. Loop After going through this piece of code, I want to get new data from the website. So the macro should run automatically after every 30 seconds. How can I achieve this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing cells continuously | Excel Worksheet Functions | |||
Leave Cell Blank Continuously | Excel Worksheet Functions | |||
procedure continuously being called | Excel Programming | |||
Need continuously running macro when conditions are met | Excel Programming | |||
Continuously accessible form | Excel Programming |