View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] vernalGreens@gmail.com is offline
external usenet poster
 
Posts: 6
Default 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?