View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RAFAAJ2000[_2_] RAFAAJ2000[_2_] is offline
external usenet poster
 
Posts: 75
Default Setting a Windows Scheduler Task via VB !

Hi all,

I am looking for some VBA code that will enable me to add a Job to the
Windows Scheduler so that Excel is started at a specified time, a specific
workbook is then opened automatically, some data is updated and finally, the
Application Closes down.

I know this could easily be done via the Windows Interface, but I am curious
to know how it is done programatically.

I have been experimenting with some code but i am still not quite there.

Regards.