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.
|