Running a macro at a specific time

**novice2430** · 06-05-2009, 06:53 PM

I'm sure someone has asked this before but when I search I get an error message.

I want to know if I can schedule a macro to run at specific times?
If so would 6 requests at the same time slow excel down?

**shg** · 06-05-2009, 07:04 PM

There are good examples in VBE Help for how to use the OnTime method.

If so would 6 requests at the same time slow excel down?

They will run sequentially, not at the same time. How long it takes depends entirely on the macros.

**novice2430** · 06-05-2009, 07:06 PM

Finally was able to search...
I found this:

Please Login or Register  to view this content.

I'm guessing 00:01:00 will make the macro run every minute?

**shg** · 06-05-2009, 07:07 PM

It will schedule it to run once one minute from Now.

**novice2430** · 06-05-2009, 07:13 PM

So how can I get it to run every 7 minutes, from 9:30 am to 1:30 pm?

I'm new to VBA.

**shg** · 06-05-2009, 07:22 PM

The macro can use the same method to reschedule itself for 7 minutes later, each time it runs.

You can search the forum for OnTime for many examples, or Google for many more.