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
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
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" wrote in message
...
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

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