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