Change Microsoft Scheduler?

[Guest]

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

 

[RB Smissaert]

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