Thread: Run a Macro via a Scheduled Time
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default Run a Macro via a Scheduled Time
Chip Pearson has lots of instructions at:
http://www.cpearson.com/excel/ontime.htm

John wrote:

I wish to run a particular macro every morning at 9:45am. I believe you use
Application.on Time

Could anyone assist me in the code I would use to say run a macro called
"Generate_Report" at 9:45am each morning

Thanks

--

Dave Peterson
Reply With QuoteReply With Quote