COM for Excel
As of 2018 we have run into problems with running the COM service 'excel.application' from a scheduler.
- Warning: Excel may not work correctly in a scheduled job unless these configuration changes are applied.
Excel may requires the folders below when it's run from a scheduler e.g. not interactively. Create both folders even if you are on a 64-bit OS. https://superuser.com/questions/579900/why-cant-excel-open-a-file-when-run-from-task-scheduler
Folders Required By Excel for Non-Interactive Sessions/Jobs
Add the user running the scheduler to the folder security with full access
Changing Security on Files
Determine the username that runs the jobs in the scheduler.
- In file explorer, locate the file and right click it's listing.
- Click Security Tab
- Add the username to the Group or user names box.
- Allow Full control in the Permissions ... box.