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)



"Colibri_2" wrote in message
...
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)?

See:

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


--
Gary''s Student
gsnu200705


"Colibri_2" wrote:

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

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

On Tue, 13 Feb 2007 11:56:00 -0800, Colibri_2
wrote:

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

Which I neglected to post.

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


Gord



On Tue, 13 Feb 2007 12:24:09 -0800, Gord Dibben <gorddibbATshawDOTca wrote:

See Chip Pearson's site for OnTime code.