Hi all,

Is there any way I can schedule / code a workbook so that it opens at a
certain time?

I have a code that runs as soon as the workbook is opened, and I need that
workbook to open at a certain time each day though.

Is this possible?!?

Thanks,

Mike

Use Task Scheduler.

mike_vr wrote:

Hi all,

Is there any way I can schedule / code a workbook so that it opens at a
certain time?

I have a code that runs as soon as the workbook is opened, and I need that
workbook to open at a certain time each day though.

Is this possible?!?

Thanks,

Mike

Hi Mike,

Go to Control Panel - Scheduled Tasks.
Click on Add Scheduled Task
Click Next
Then browse to your workbook, select it and click Open.
Then set your scheduled time as prompted.
Then enter your logon credentials when prompted.
Then click finish.
Then double click the task to open it and ensure that the "Run Only if
Logged on" option is NOT hooked (otherwise your task will not run unless you
are logged on).

Hope this helps.
(I have assumed you are using Windows XP)

Cheers
J-P

"mike_vr" wrote:

Hi all,

Is there any way I can schedule / code a workbook so that it opens at a
certain time?

I have a code that runs as soon as the workbook is opened, and I need that
workbook to open at a certain time each day though.

Is this possible?!?

Thanks,

Mike