Code Execution Hangs When Run by the Task Scheduler

I am troubleshooting this macro as part of a larger issue.

I run a task on the Windows Task Scheduler. It opens an Excel workbook script. The script has an on open event that opens a target Excel workbook, and executes a macro in that workbook.

This system works for my other files with the exception of one file that “hangs” and will not complete execution.

If the script is kicked off by the task scheduler and I am not logged in, the task fails.

If the script is kicked off by the task scheduler and I am logged in, the task fails.

If the script is kicked off by me running the task scheduler manually, it runs successfully.

If the script is kicked off by the task scheduler and I am logged in but unchecked the box that says “Run whether the user is logged in or not,” it runs successfully.

Have I forgotten any combination?

Since the task scheduler works for other scripts (all of which use the same code) and target workbooks, I suspect the problem is with this workbook and not the task scheduler.

I created a macro, AppendToLog, that writes a time stamp and a string to a text log. I placed a number of these statements in the code so I can track its execution.

Attached is a copy of the log for last night’s run. Also shown below is the code that is running. The line on which the code stopped executing is highlighted in red. This failure point “moves around” slightly as I add or delete code above it. It seems like the code executes a fixed number of lines of code and then stops. Is this possible?

My apologies for not including the workbook, but there is simply too much proprietary data to replace with desensitized data.

I am also going to cross-post this to the Microsoft Community.

FYI: Windows 7 Professional, Office 2016. I’ve only started seeing this issue since upgrading to 2016. The same script and target work just fine on my laptop Windows 7 Professional, Office 2013. And yes, I did an offline repair on office 2016.

Please Login or Register  to view this content.