Differences

This shows you the differences between two versions of the page.

--- excel:automation [2024/03/07 16:01] – created su
+++ excel:automation [2024/03/07 16:17] (current) – su
@@ Line 87: / Line 87: @@
 Use the start menu to search for "Task Scheduler"
 {{ :excel:search.png?400 |}}
+Click "Create Task" in the right panel.
+{{ :excel:create-task.png?400 |}}
+Enter a name for the task. Select the "Triggers" tab the click "New" to setup when the report will be run.
+{{ :excel:triggers.png?400 |}}
+Then select the "Actions" tab.
+{{:excel:example-action.png?400 |}}
+Click "New". Make sure "Start a Program" is selected for "Action".
+In the Program/Script field enter the path to the Power shell exe on your system.
+<code>
+C:\Program Files\PowerShell\7\pwsh.exe
+</code>
+Set the arguments to the path to the script e.g.
+<code>
+C:\dev\excel-report\export-pdf.ps1
+</code>
+Set the "start in" field to the wolder with the script, add-in and excel file. e.g.
+<code>
+C:\dev\excel-report
+</code>