From here: https://superuser.com/questions/579900/why-cant-excel-open-a-file-when-run-from-task-scheduler
1. Open Component Services (Start -> Run, type in dcomcnfg)
2. Drill down to Component Services -> Computers -> My Computer and click on DCOM Config
3. Right-click on Microsoft Excel Application and choose Properties
4. In the Identity tab select This User and enter the ID and password of an interactive user account (domain or local) and click Ok
Keeping it as the interactive user or the launching doesn't work with the task scheduler unfortunately, even when setting the task up to run under an account that has admin access to the machine.
4a55fc18-c1aa-41f2-a3e9-d8c0e37c1676|0|.0
From here: https://forums.asp.net/t/1740537.aspx?Microsoft+Excel+cannot+access+the+file+is+solved+by+creating+a+folder
These are the steps for resolving the issue. If I ran Task Scheduler on demand it worked, but it would not interact with Excel of it was Triggered by the timer!
Run> dcomcnfg
This will open Component Services and navigate to Console Root
\Component Services\Computers\My Computer\DCOM Config\Microsoft Excel Application
Right click Microsoft Excel Application and select Properties
Click on Identity Tab and check selection.
It works for me when select option - The interactive user
62db016c-2300-47a9-96d4-30b7a3504096|0|.0
This is a brilliant service! It's not 100% perfect but pretty cool and saved me hours on manually typing!
https://pdftables.com/
Enjoy
684b9ccf-c191-4263-8595-997ba3c0092e|0|.0
Rename a chart
When you create charts, Microsoft Office Excel assigns a default name to each chart by using the following naming convention: Chart1, Chart2, and so on. However, you can change the name of each chart to make it more meaningful to you.
- Click the chart that you want to rename.
This displays the Chart Tools, adding the Design, Layout, and Format tabs.
- On the Layout tab, in the Properties group, click the Chart Name text box.
Tip You may have to click the Properties icon in the Properties group to expand the group.
- Type a new name.
- Press ENTER.
e42e2f2d-26ab-4238-8562-a036a2821b58|0|.0