scheduling macros to run automatically

[Guest]

Dear all,

I have a quick question regarding macros. What is the best (and easiest)
way to have macros run automatically at prespecified times? Thanks.

 

[Toyin.Butler]

I use Application.OnTime

Say you woould like to run MySub at 12:00

Sub Run()

Application.OnTime date + 12:00, "MySub"


End Sub

hth

Toy.

 

[Guest]

If you are talking about on a daily basis, then use the windows scheduler to
open a workbook at a certain time(s).

In the workbook_open event call your macros (in that workbook).

http://www.cpearson.com/excel/events.htm for an overview of events

if you just want to schedule a few things to happen when you already have
excel open you can look at:
http://www.cpearson.com/excel/ontime.htm