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?
On Dec 14, 1:40 pm, vernalGre...@gmail.com wrote:
> My macro fetches data from a website. I want this macro to get the data
> every 30 seconds.
[quoted text clipped - 9 lines]
> website. So the macro should run automatically after every 30 seconds.
> How can I achieve this?
You might want to take a look at Application.OnTime (just search the
VBA help for "OnTime").
Mike
vernalGreens@gmail.com - 15 Dec 2006 07:16 GMT
application.ontime helped.
Thanks
> On Dec 14, 1:40 pm, vernalGre...@gmail.com wrote:
> > My macro fetches data from a website. I want this macro to get the data
[quoted text clipped - 15 lines]
>
> Mike