We do a lot/most of our basic reporting in Business Objects and then export
to Excel and then run macros to provide the finished product. We can
pre-schedule BO reports to run which is great. Now, if only we could
pre-schedule the Excel macors to run at pre-set times, based on, say, our
computer's internal clock. The "Vision": at 1:00AM BO kicks off and generates
a set of reports and places them in the "output folder" by 3:00AM. At 3:00AM
an Excel macro (Excel has been up/open on the desktop computer all night)
automatically executes to go find the reports in the "output folder" and
"massage" the data and then place it in another special folder for automatic
emailing. Sounds cool, huh?

I've done roughly the same using an Auto_Open macro in an Excel workbook, and
invoking that workbook via Windows Task Scheduler. Note that you'll want to
'sign' your macro and be certain that the signer is trusted on the PC on
which you're going to have the macro kick off (otherwise, Excel will start,
then sit there waiting for you to enable macros).

"Colibri_2" wrote:

We do a lot/most of our basic reporting in Business Objects and then export
to Excel and then run macros to provide the finished product. We can
pre-schedule BO reports to run which is great. Now, if only we could
pre-schedule the Excel macors to run at pre-set times, based on, say, our
computer's internal clock. The "Vision": at 1:00AM BO kicks off and generates
a set of reports and places them in the "output folder" by 3:00AM. At 3:00AM
an Excel macro (Excel has been up/open on the desktop computer all night)
automatically executes to go find the reports in the "output folder" and
"massage" the data and then place it in another special folder for automatic
emailing. Sounds cool, huh?