System time to activate a routine? Possible??

rob_sheeds

Board Regular
Joined
Dec 9, 2010
Messages
57
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!!
 

Some videos you may like

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

Trevor G

Well-known Member
Joined
Jul 17, 2008
Messages
6,672
Office Version
  1. 2016
Platform
  1. Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,973
Messages
5,525,988
Members
409,673
Latest member
Riseee

This Week's Hot Topics

Top