JeffGrant
Well-known Member
- Joined
- Apr 7, 2021
- Messages
- 516
- Office Version
- 365
- Platform
- Windows
Hi All,
In my model I have a lot of Application.Ontime events, generally >100 per day & > 300 on a weekend.
On the whole every thing works fine, however, I do find that the Ontime method does stop on it's own and for now apparent reason.
Step 1. Ontime runs a python download script for an API
Step 2. Ontime does some data copying
Step 3. Ontime does some calculations
Step 4. Ontime runs another python upload script for an API
Excel does not close down, other code runs fine, there is no cancellations, but Ontime stops.
But sometimes, these 4 steps can run into each other and overlap, could that cause a stoppage?
Given that my model run largely in an unattended mode, when it stops, everything stops.
Has anybody experienced this before and is their a potential way of checking if Ontime stops when the PC is unattended?
As always, thanks for your help & guidance.
In my model I have a lot of Application.Ontime events, generally >100 per day & > 300 on a weekend.
On the whole every thing works fine, however, I do find that the Ontime method does stop on it's own and for now apparent reason.
Step 1. Ontime runs a python download script for an API
Step 2. Ontime does some data copying
Step 3. Ontime does some calculations
Step 4. Ontime runs another python upload script for an API
Excel does not close down, other code runs fine, there is no cancellations, but Ontime stops.
But sometimes, these 4 steps can run into each other and overlap, could that cause a stoppage?
Given that my model run largely in an unattended mode, when it stops, everything stops.
Has anybody experienced this before and is their a potential way of checking if Ontime stops when the PC is unattended?
As always, thanks for your help & guidance.
