execute macro at certain time

[Frodo]

I would like to have a macro execute automatically at a certain time
each day. Does anyone know if this is possible?

Thanks



------------------------------------------------


-- View and post Excel related usenet messages directly from http://www.ExcelTip.com/forum
at http://www.ExcelTip.com/
------------------------------------------------

 

[Dave Peterson]

You gonna keep excel open?

If yes, take a look at Chip Pearson's notes:
http://www.cpearson.com/excel/ontime.htm

You also may want to look at a scheduler program (some versions of windows have
this built in, but there are lots of shareware programs that do it, too
(www.shareware.com).)

Then that windows scheduler program can start your file at 8:00 and your
workbook could have an auto_open macro that runs when the workbook opens.