Run a Macro via a Scheduled Time
 

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

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