Code for opening a workbook at a specific time!?!
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 |
Code for opening a workbook at a specific time!?!
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 |
Code for opening a workbook at a specific time!?!
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 |
All times are GMT +1. The time now is 11:00 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com