Run a macro continuously

V

vernalGreens

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

Mike Woodhouse

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?
Click to expand...

You might want to take a look at Application.OnTime (just search the
VBA help for "OnTime").

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Should I be content with the time code takes? 2
Self Closing MsgBox 6
Stop my timer 4
Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0
Make code aware of the workbook file name 4
Start a macro from a change in a cell value made by a formula? 7
Macro speed decreesing after each run 6
Using vbe to launch a custom show on advancement to specific slide 1

Top