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

[Colibri_2]

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

 

[Bob Phillips]

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)

 

[Gary''s Student]

See:

http://www.cpearson.com/excel/ontime.htm

 

[Gord Dibben]

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

 

[Gord Dibben]

Which I neglected to post.

http://www.cpearson.com/excel/ontime.htm


Gord