Informative piece on scheduling procedures on your site Chip

"Chip Pearson" wrote in message
...
No. Excel will open the workbook when the OnTime event triggers.


"John" wrote in message
...
Thanks Chip, Excel will be running but does the actual file have to be
open/running?

"Chip Pearson" wrote in message
...
If Excel will be up and running all the time, you can use
Application.OnTime to schedule a macro to run at a specific date and
time.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"John" wrote in message
...
I was wondering if it is possible to set-up an automatic e-mail of a
file or at least Run a macro within a file that generates an e-mail.
I've used code from Ron De Bruins excellent inf on e-mailing but can't
see anything specific on this area.

Basically I have an Excel file which I generate an e-mail from (via
macro) I need to send this out every weekend, so to save me working 7
days a week, I was wondering if there is any code that will open my
file, "click" a macro that will generate my Report then "click" another
Macro that will e-mail this Report out.

I have both the "Generate Report" and "Mail Report" set up and working,
but I need to automate the actual "clicking" of these macros, say every
Saturday and Sunday at 10:00am

Thanks