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

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

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

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

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