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?