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.

"Scott J" wrote:

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