See Chip Pearson's site for OnTime code.

Note: Excel must be running for this to happen.

Alternate method without OnTime..........put your macro code in Thisworkbook
Workbook_Open routine.

Then use Windows Task Scheduler to start Excel, open the workbook, which runs
the code and saves/closes the workbook and closes Excel or whatever you want to
do.


Gord Dibben MS Excel MVP

On Tue, 13 Feb 2007 11:56:00 -0800, Colibri_2
wrote:

We work a lot in Business Objects and then have to manually execute Excel
macros to produce our reports. Is there a way to tell/schedule an Excel macro
to run/execute automatically at a certain time of day (say, based on your
computer's internal clock)?