ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Change Microsoft Scheduler? (https://www.excelbanter.com/excel-programming/366623-change-microsoft-scheduler.html)

Nicole Seibert

Change Microsoft Scheduler?
 
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

Change Microsoft Scheduler?
 
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




All times are GMT +1. The time now is 07:32 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com