how to schedule macros

K

khan

I have a micro that needs to be run every hour. Anyone has
any idea how to do that.
Thanks.
 
A

Andre

You would need a form and then use the On Timer Event on the form to run the
query.

See the help file regarding the On Timer Event of the form. You use the
Timer Interval to set an interval equal to 1 hour using milliseconds.

When the form is opened, the timer runs for x milliseconds and then triggers
the On Timer event which in turn can trigger your macro

HTH
Andre
 

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

Need Help with Macro Security 1
Macro to copy table of contents to a new doc 0
Can we use outlook calendar as an universal place post work schedules for all the users? 0
Macro warning in word 1
Work Budget Salary vs Real Time Salary 0
How to set a rotating shift schedule for 4 crews with repeat occurrence? -SOLVED 1
Autonumber field in Excel that behaves the same as Access 0
VBA word change keys 0

Top