ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Open excel at a set time (https://www.excelbanter.com/excel-programming/363617-open-excel-set-time.html)

Nicole Seibert

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?!?!!!!

Steph

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?!?!!!!




witek

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.

Dave Peterson

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