How do you run an excel macro automatically overnight?

S

Scott J

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
 
B

bpeltzer

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