Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 152
Default Can VBA modify Task Schedular tasks in XP

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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,452
Default Can VBA modify Task Schedular tasks in XP

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


"MikeZz" wrote in message
...
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


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 53
Default Can VBA modify Task Schedular tasks in XP

"MikeZz" je napisao u poruci interesnoj
...

As an alternative, could I have excel run a file that's associated with an
application?



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


  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,203
Default Can VBA modify Task Schedular tasks in XP

I found a copy of tskschd.dll inside of the .zip file that is available
through:
http://www.mvps.org/emorcillo/en/code/vb6/index.shtml
there's a topic on that page:
Using the Task Scheduler
with this link:
http://www.mvps.org/emorcillo/download/vb6/schedule.zip
tskschd.dll is part of that .zip file.

Do you have a link to documentation about using the dll?


"RB Smissaert" wrote:

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


"MikeZz" wrote in message
...
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


.

  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,452
Default Can VBA modify Task Schedular tasks in XP

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


"JLatham" wrote in message
...
I found a copy of tskschd.dll inside of the .zip file that is available
through:
http://www.mvps.org/emorcillo/en/code/vb6/index.shtml
there's a topic on that page:
Using the Task Scheduler
with this link:
http://www.mvps.org/emorcillo/download/vb6/schedule.zip
tskschd.dll is part of that .zip file.

Do you have a link to documentation about using the dll?


"RB Smissaert" wrote:

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


"MikeZz" wrote in message
...
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


.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
display a complete list of tasks by selecting on a task matt Excel Discussion (Misc queries) 1 July 6th 09 04:32 PM
Task Manager (shut down a task if active) Brettjg Excel Programming 2 February 21st 09 05:01 AM
List Outlook tasks from another person's shared task list Notawahoo Excel Programming 0 January 10th 07 07:16 PM
Gantt chart - fill show progress of tasks over task time period??? JohnHamer1977 Excel Discussion (Misc queries) 3 August 29th 06 05:41 AM
dialog box for active cell task to speed repeditive task Todd F.[_2_] Excel Programming 3 August 9th 05 02:30 PM


All times are GMT +1. The time now is 05:46 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"