Start macro at a special time

[Sean]

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