I have two Excel files the first is a record log of the job being run ie this particular file is scheduled to be open by Window's Task Scheduler; timestamps two cells for the start/end of the job being run and then opens the second Excel file which runs code upon opening. Everything is fine with the code as I can run it just perfectly via Terminal Services
My issue is that it occassionally hangs when the service is scheduled to run the Task Scheduler. The first file is opened and somewhere along the way it hangs up. Is there a way to capture the point where it may be hanging up? I know it is not a scheduled task issue as it does kick off.
Your thoughts are appreciated,