Code for opening a workbook at a specific time!?!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top