How to run a macro at a specific time tomorrow (Excel 97)

Topic

New Reply

How can I set a macro to run at a specific time tomorrow using .OnTime?

Ron

Reply | Quote

Replies

You might want to play with something like the following;

In cell A1 type 9/16/2004 11:18:35 PM or something like =Now()+1 ‘Adjust to the date and time you want the macro to run

In the Workbook_Open event try the following
Application.OnTime EarliestTime:=Range(“A1″), _
Procedure:=”my_Procedure”

Paul

Reply | Quote

You might want to play with something like the following;

In cell A1 type 9/16/2004 11:18:35 PM or something like =Now()+1 ‘Adjust to the date and time you want the macro to run

In the Workbook_Open event try the following
Application.OnTime EarliestTime:=Range(“A1″), _
Procedure:=”my_Procedure”

Paul

Reply | Quote

Note that using ontime will require that excel is running.

You might also lok at using something like Windows Scheduler to open a file in excel and have the macro run from the workbook open event.

Steve

Reply | Quote

Note that using ontime will require that excel is running.

You might also lok at using something like Windows Scheduler to open a file in excel and have the macro run from the workbook open event.

Steve

Reply | Quote

To run MyProc tomorrow at 1:00:00 PM, use the following:

    OnTime Date + 1 + TimeValue("1:00:00 PM"), MyProc

Remember that Excel must remain active until that time.

Reply | Quote

To run MyProc tomorrow at 1:00:00 PM, use the following:

    OnTime Date + 1 + TimeValue("1:00:00 PM"), MyProc

Remember that Excel must remain active until that time.

Reply | Quote