Run macro at the start of every hour

[sjd11]

I have a macro I need to run every hour. I have tried several different ways of doing this and every time I have the same result. My macro runs 2 or 3 times. If i run the macro manually it seems to work fine.
Please help me work this out.

 

[rstitzel]

If your using a Microsoft operating system, have you tried using the "scheduler" in the control panel? You can create a shortcut on your desktop to the macro. Just drag the macro with your right mouse button to your desktop. Go to control panel, click scheduled tasks, Add scheduled task, next, browse to desktop, click the shortcut you created, click daily, click next, fill in account information, next, check the "Open Advanced Properties etc." check box, finish, click schedule, change start time to 12:00 am, click advanced, click repeat task. Run every 60 minutes, UNTIl time 11:59 pm, click ok, click apply, click ok Every 60 minutes the system should open Access and run the macro. You may want to add closing the database to the end of that macro. Not sure if that will work but it may worth a try.

 

[electricpete]

Some info about timer functions available

http://www.cpearson.com/excel/OnTime.aspx