![]() |
Open excel at a set time
Okay. So, I have read over CPearson's and The Hawley's take on running macros
at a set time. Both of which are telling me that Excel much be open before the macro can run. What if I want to run a macro at 3am -- when I will never be at work?!?!!!! |
Open excel at a set time
How about using the Microdoft Scheduler. That will allow you to open an
excel file at a specific time. Then just have your macro that you want run as an Open Event. "Nicole Seibert" wrote in message ... Okay. So, I have read over CPearson's and The Hawley's take on running macros at a set time. Both of which are telling me that Excel much be open before the macro can run. What if I want to run a macro at 3am -- when I will never be at work?!?!!!! |
Open excel at a set time
Nicole Seibert wrote:
Okay. So, I have read over CPearson's and The Hawley's take on running macros at a set time. Both of which are telling me that Excel much be open before the macro can run. What if I want to run a macro at 3am -- when I will never be at work?!?!!!! Windows? use Task Scheduler to open specific file which contains macros. |
Open excel at a set time
Just to add to Steph's notes...
Your PC will have to be turned on <bg. and macro security level will have to be set to low. === Ps. I use a freeware program called nnChron Lite http://www.nncron.ru/ It has the option of running scheduled tasks when the pc is turned on--if the scheduled time had passed while the pc was off. Steph wrote: How about using the Microdoft Scheduler. That will allow you to open an excel file at a specific time. Then just have your macro that you want run as an Open Event. "Nicole Seibert" wrote in message ... Okay. So, I have read over CPearson's and The Hawley's take on running macros at a set time. Both of which are telling me that Excel much be open before the macro can run. What if I want to run a macro at 3am -- when I will never be at work?!?!!!! -- Dave Peterson |
All times are GMT +1. The time now is 03:18 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com