View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Cheryl Cheryl is offline
external usenet poster
 
Posts: 144
Default Auto launch application & run macro

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