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

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

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

It has to remain 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

So actually,

There is no code which allows a macro to run at a specific date?

Fe Monday July 19 2004 at or after 1 pm


Adios,
Mischa


"Tom Ogilvy" schreef in bericht
...
It has to remain 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

Mischa,

Try

Application.OnTime DateSerial(2004,7,19) + TimeSerial(13,0,0),
"MacroName"

Note that Excel must remain open from the time you execute the
OnTime macro until the scheduled time.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Mischa Browne" wrote in message
...
So actually,

There is no code which allows a macro to run at a specific
date?

Fe Monday July 19 2004 at or after 1 pm


Adios,
Mischa


"Tom Ogilvy" schreef in bericht
...
It has to remain 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

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