Setting a Windows Scheduler Task via VB !

[RAFAAJ2000]

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.

[Vasant Nanavati]

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" <RAFAAJ2000@discussions.microsoft.com> wrote in message
news:898FC5DC-0657-4A59-80F1-A8538B2DEB31@microsoft.com...
> 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.
>
>