View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Vasant Nanavati Vasant Nanavati is offline
external usenet poster
 
Posts: 1,080
Default Setting a Windows Scheduler Task via VB !

If your VBA code is in Excel, it will not run unless Excel is open. So I'm
not sure how you could accomplish this with pure VBA.

--

Vasant

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