Solved: Create and Edit a Scheduled Task from Excel

[scott56]

I have an Excel workbook that is to be opened by a scheduled task do some checks on the current date and things in the workbook and then close.

I have been able to create the scheduled task using the standard Windows Scheduled Task application and a vbs script....

But I now want to send this to other users that do not know or want to know how to create a scheduled task. So I want to provide them with some basic options in an Excel workbook that will allow them to create and then if needed edit a scheduled task.

Can anyone tell me how I can use Excel / VBA to create a scheduled task and then when required edit that scheduled task via Excel / VBA ?

Any help and assistance is much appreciated...

[Tinbendr]

Search is your friend.

[scott56]

Thanks for that .....I had tried to search and did not find this