running macros at specified time

  • Thread starter Thread starter Davo1
  • Start date Start date
Will Excel be running at all times?

Will the workbook with the macros be open at all times?

A macro can be run at a certain time using the OnTime method but Excel and
the workbook must be open.

Alternative..................

Task Scheduler to start Excel at a given time with the workbook to open and
Workbook_Open code to do the macro work is one method.

You would not have to use OnTime method.


Gord Dibben MS Excel MVP
 

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

Run Macro on multiple files 4
Running a macro based on the time 1
Excel 2007: Help creating a macro that will run Solver? 3
Excel TWO Instances of Excel One watching Other 3
Run Macro If Cell have "x" value 0
Macro Help 1
Resetting up Excel 2003. Is there a fast simple way to re-associatemacros with macro buttons? 1
is there a way to schedule a macro to execute at a certain time? 4

Back
Top