scott56
02-16-2011, 02:16 PM
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...
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...