Can VBA modify Task Schedular tasks in XP

  • Thread starter Thread starter MikeZz
  • Start date Start date
M

MikeZz

Hi,
I have a lot of schedualed tasks where I need to be able to quickly adjust
the start time on a regular basis.

I was wondering if there was a way VBA could modify the tasks in task
schedular?

I'd be looking to at least be able to adjust the start time but preferably
also delete and add tasks.

As an alternative, could I have excel run a file that's associated with an
application?
And if I could, how could I run it around the clock so it could do the same
thing as XP Task Schedular?

Thanks,
MikeZz
 
If you get the superb .dll file tskschd.dll, written by Edanmo Morgilllo
this can be done quite easily.
Not sure now where it can be downloaded from.

RBS
 
As an alternative, could I have excel run a file that's associated with an
application?
Click to expand...


first, there is cmd line task scheduler command 'at', type at/? at cmd
prompt
next, from excel vba, you may run vbscript, which in turn has ability to run
commands, like 'at'
you just need to compose text for 'at' command, call vbscript to execute
that command
with 'at', you may add, modify and delete scheduled tasks entries

but obviously, there is no need to use excel at all, simply type command at
cmd prompt of you windows
 
Do you have a link to documentation about using the dll?

Not sure there is any documentation, I had to figure it out by trial and
error.
Let me know if you need some example code and I will post it here.

RBS
 
Back
Top