Schedule Run of VBA

[BUDDY]

Can I create code that starts a program at a given date
and time -- like using Scheduler? Or would I want to use
a .bat file in Scheduler that opens my workbook. The
workbook would have a Event Procedure that started the
code upon opening????? Am I warm here?

Thanks!

 

[Frank Kabel]

Hi
you may have a look at the OnTime method. See
http://www.cpearson.com/excel/ontime.htm

 

[BUDDY]

Thanks for the response. It looks a bity daunting to a
beginner, but I'll give it a shot. Thanks again.