System time to activate a routine? Possible??

[rob_sheeds]

Is it possible to have Excel open and have the system time initiate a routine? Everything else in a report is done by code, so is there a way i wouldnt even need to remember to open the sheet and press a button?
Lazy, yes, but would stop missing deadlines for daily reports.
THanks!!

 

[Trevor G]

If you have access to the Control Panel on your PC you can set up a Schedule to activate the workbook and macros at given times.

 

[VoG]

Take a look at the OnTime method http://www.ozgrid.com/Excel/run-macro-on-time.htm

 

[dave3009]

You could use the task scheduler for this

http://support.microsoft.com/kb/308569

 

[rob_sheeds]

Excellent, thanks all!!