You can do it directly with the Windows API, but is much easier to use
Edanmo's free dll:
http://www.mvps.org/emorcillo/en/code/vb6/index.shtml
Towards the bottom of the page: Using the Task Scheduler
RBS
"Nicole Seibert" wrote in message
...
Hi fellow helpers,
Can I change the microsoft scheduler inside excel with VBA? Specifically,
can i change the scheduled run date based on criteria found within a "upon
open" macro?
Any examples would be helpful.
Thanks,
Nicole