Hi everyone,
I want to schedule my macro to run daily at 5:00 am. From reading thru the
threads, I believe I need to record a Sub Auto_Open to launch the Excel
application and to then run the macro? In setting up the scheduled task, the
wizard will ask for the application. How do you designate the vba code to
run? Thanks for all the great knowledge y'all have provided for novices like
me!
Cheryl

Cheryl

Sub Auto_Open does not launch Excel.

Windows Task scheduler starts Excel at the given time with your workbook to
open.

The Sub Auto_Open() runs the code when the workbook opens.


Gord Dibben MS Excel MVP


On Tue, 3 Apr 2007 13:08:01 -0700, Cheryl <(E-Mail Removed)>
wrote:

>Hi everyone,
>I want to schedule my macro to run daily at 5:00 am. From reading thru the
>threads, I believe I need to record a Sub Auto_Open to launch the Excel
>application and to then run the macro? In setting up the scheduled task, the
>wizard will ask for the application. How do you designate the vba code to
>run? Thanks for all the great knowledge y'all have provided for novices like
>me!
>Cheryl

Ok, what is the easiest method to run a macro as an unattended task w/o
opening Excel?

Thanks,
Cheryl


"Gord Dibben" wrote:

> Cheryl
>
> Sub Auto_Open does not launch Excel.
>
> Windows Task scheduler starts Excel at the given time with your workbook to
> open.
>
> The Sub Auto_Open() runs the code when the workbook opens.
>
>
> Gord Dibben MS Excel MVP
>
>
> On Tue, 3 Apr 2007 13:08:01 -0700, Cheryl <(E-Mail Removed)>
> wrote:
>
> >Hi everyone,
> >I want to schedule my macro to run daily at 5:00 am. From reading thru the
> >threads, I believe I need to record a Sub Auto_Open to launch the Excel
> >application and to then run the macro? In setting up the scheduled task, the
> >wizard will ask for the application. How do you designate the vba code to
> >run? Thanks for all the great knowledge y'all have provided for novices like
> >me!
> >Cheryl
>
>

Cheryl,
Not possible; Excel must be open for macros to run.
As Gord says, you can use the Windows Scheduler to open an Excel file at the
required time.
Code in the Auto_Open routine (or preferably the Workbook_Open event) will
then run.

NickHK

"Cheryl" <(E-Mail Removed)> wrote in message
news:3E260121-10E6-4FCE-BEA4-(E-Mail Removed)...
> Ok, what is the easiest method to run a macro as an unattended task w/o
> opening Excel?
>
> Thanks,
> Cheryl
>
>
> "Gord Dibben" wrote:
>
> > Cheryl
> >
> > Sub Auto_Open does not launch Excel.
> >
> > Windows Task scheduler starts Excel at the given time with your workbook
to
> > open.
> >
> > The Sub Auto_Open() runs the code when the workbook opens.
> >
> >
> > Gord Dibben MS Excel MVP
> >
> >
> > On Tue, 3 Apr 2007 13:08:01 -0700, Cheryl
<(E-Mail Removed)>
> > wrote:
> >
> > >Hi everyone,
> > >I want to schedule my macro to run daily at 5:00 am. From reading thru
the
> > >threads, I believe I need to record a Sub Auto_Open to launch the Excel
> > >application and to then run the macro? In setting up the scheduled
task, the
> > >wizard will ask for the application. How do you designate the vba code
to
> > >run? Thanks for all the great knowledge y'all have provided for
novices like
> > >me!
> > >Cheryl
> >
> >