Apllication.OnTime
Of course you could write code to save the scheduled date and time and
reinitiate the ontime event using the workbook_open event. But just setting
Ontime does not persist when you close excel. (I guess I should have said
you need to keep excel open - I don't believe you need to keep that specific
workbook open).
--
Regards,
Tom Ogilvy
"Mischa Browne" wrote in message
...
Dear Peter,
Thanks, but does this mean I have to keep the workbook (that contains the
macro) active until tomorrow.
Or can I just open the workbook, tomorrow and then the macro will run?
MRegards,
Mischa
"Peter Beach" schreef in bericht
...
Hi Mischa,
If you give a full date/time OnTime will work to that date. Something
like:
Application.OnTime Date + 1 + Time(12,0,0), "MyRoutine"
will run at noon tomorrow.
HTH
Peter Beach
"Mischa Browne" wrote in message
...
Goodday,
You can use "OnTime" method to schedule a macro to run at a specific
time.
Is there also a method to schedule a macro to run at and/or after a
specific
date (system-date)?
TKs,
Mischa
|