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.
 
Back
Top