is there a way to schedule a macro to execute at a certain time?

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

Guest

We work a lot in Business Objects and then have to manually execute Excel
macros to produce our reports. Is there a way to tell/schedule an Excel macro
to run/execute automatically at a certain time of day (say, based on your
computer's internal clock)?
 
Use the OS scheduled task function to open Excel with a specified workbook
which has a Workbook_Open procedure.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
See Chip Pearson's site for OnTime code.

Note: Excel must be running for this to happen.

Alternate method without OnTime..........put your macro code in Thisworkbook
Workbook_Open routine.

Then use Windows Task Scheduler to start Excel, open the workbook, which runs
the code and saves/closes the workbook and closes Excel or whatever you want to
do.


Gord Dibben MS Excel MVP
 
Back
Top