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