Start macro at a special time

[Guest]

Hi,

I'd like to start a macro at a special time, say 9:30am, every day. How can
i do it?

Thanks.

 

[eshirley]

Sean,

There are two options:

One is to call the macro you want run from the Workbook Open procedure
and then use the operation system to open the workbook each day at
9:30. Open the Help for you operating system and search for "Create a
Scheduled Task" for instructions.

The other option, which demands more processing time is to create a
macro that checks the time every so often and executes the macro when
the time reaches a certain point. This macro would have to run 24
hours a day and use the Date function to check the time. If the
Workbook is closed or the computer shut down that Macro execution would
be halted until restarted.

Good Luck

 

[Joe HM]

Hello -

What about using the Application.OnTime function?

Joe