Powershell+Task Scheduler+Excel. The script does not work, Excel does not start when you run the script from the scheduler. How to fix?

Question

PowerShell

Good afternoon!
I wrote a script that collects information, puts it into Excel using a COM object. Saves and closes Excel.
If you just run under the user, then everything is OK.
I put the launch in the scheduler and the script does not work ..
Judging by the Task Manager, Excel does not even start.
I need a launch not from the SYSTEM, but from the domain user.
User in server administrators.
Please tell me how to solve the problem. Thanks in advance.

Answer 1

and if the task in the scheduler is run from a specific domain user and remove the Run with highest privileges checkbox?

Answer 2

The user under which the task is launched is configured in the scheduler in the task settings.
Note that when run from the scheduler, the current directory is usually c:\windows\system32, not the script directory. Often errors when running from the scheduler are related precisely to the fact that the script expects the current directory to be the directory where the script itself is located.

Answer 3

Most likely, there is a checkmark in the settings so that the task is performed for users who have logged in. And if no one entered the system, then the task is not executed. Try setting it up so that the task runs even if no one is logged on.
+ look at the job logs in the same console. An error will be written there, why the task was not completed. If there was no error, then it simply did not even start, and therefore some of the conditions were not met.

Answer 4

You need to change the value from "Running User" to "Current User" in the following location:
Control Panel - Administrative Tools - Component Services - Computers - My Computer - DCOM Setup - Microsoft Excel Application - Properties - Identity.