How do you run an excel macro automatically overnight?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to schedule several excel macro to run overnight to format and
distribute several reports to co-workers and other stakeholders.

I would appreciate any and all suggestions
 
My approach has been to create an AutoOpen macro in Excel (it's got to be
signed by a digitial certificate that you've 'trusted'). Then run the Excel
file via a Windows scheduled task.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro Compatability 1
Excel 2007 macro compatability 1
Run Macro Automatically When Excel 2003 Opens 2
How to code VBA or else to open Excel and run Macro as Daily routi 4
Automatically run an Excel macro 3
sharing macros with other users 3
Red Text in Formula Bar 2
Printing using Macros for Multiply Co-workers in Excel 2

Back
Top