Open excel at a set time

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

Guest

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?!?!!!!
 
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 said:
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?!?!!!!
Click to expand...


Windows?
use Task Scheduler to open specific file which contains macros.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Excel - Select a value from one cell in Excel to update a SQL table 1
automatically trying to run a macro at a certain time 0
automatically trying to run a macro at a certain time 1
how to run a recorded macro in many files at a same time 1
Run an Excel code every 15 minutes of the clock 7
Need to run a macro on opening a new excel file 0
running a macro, while programming in vba at the same time 5
Run a recorde macro in multiple excel workbook at a time 3

Back
Top