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.

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.