Tags: automatically, basic, business, certain, excel, export, macro, macros, microsoft, msdn, objects, product, provide, reporting, run, schedule, software, time

Can I schedule a macro to run automatically at a certain time?

On Microsoft » Microsoft Excel

1,934 words with 1 Comments; publish: Fri, 23 May 2008 18:27:00 GMT; (30646.88, « »)

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?

All Comments

Leave a comment...

  • 1 Comments
    • 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?

      #1; Fri, 23 May 2008 18:29:00 GMT