I have a workbook that contains a macro that I would like to run once a week automatically.

I have set up the workbook\_open event to run the macro and the code itself runs as I would like it to.

My question is how to schedule this to automatically run on a schedule. I have setup a task in windows task scheduler which does not seem to run reliably (i've tried this on a few different projects over the years and never get great results).

My desire is to have my personal desktop run this task whether or not I am logged in. (Obviously the computer needs to be powered on which is no problem. Also, I am the only one that uses this computer, no concern about someone else being logged in)

Is there a more robust way of doing this or am I stuck with task scheduler? If so, has anyone else had better success with it that might be able to help me out?

Task scheduler seems to work only intermittently although the "history" shows it is triggered and run at the desired times. Part of the code saves a file to a location with a date stamp and there are not files for each trigger in the scheduler history.

[![Scheduler_Trigger](https://i.stack.imgur.com/AWdvq.jpg)](https://i.stack.imgur.com/AWdvq.jpg)

[![Task_settings](https://i.stack.imgur.com/6gnEQ.jpg)](https://i.stack.imgur.com/6gnEQ.jpg)

[![Task_Conditions](https://i.stack.imgur.com/NuwzD.jpg)](https://i.stack.imgur.com/NuwzD.jpg)

[![Task_History](https://i.stack.imgur.com/fw5KV.jpg)](https://i.stack.imgur.com/fw5KV.jpg)

[![Files_Created](https://i.stack.imgur.com/Rk0IX.jpg)](https://i.stack.imgur.com/Rk0IX.jpg)