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.

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.