View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default scheduling macros to run automatically

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

--
Regards,
Tom Ogilvy


"robert" wrote:

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.