Scheduling a python script with Windows task scheduler

Overview of the setup:

• W10 professional within a domain
• All scripts and files within 1 folder (not local but network drives connected to the file server)
• 2 python scripts: one to filter an Excel file (removing columns and stuff), another to edit an HTML file and fill it with the content of the excel file.

The scripts (they work perfectly, no errors or problems so no debug needed but maybe the path references are causing my main problem that I'll explain in the lower part of this post/question):

• The script to convert 1 excel file to another to filter data uses following main path references:

Reading the excel:

 df = pd.read_excel('H:\python codes\excel\planner software\planning-update.xls')

Write it:

df.to_excel('H:\python codes\excel\planner software\planning-update-filtered.xlsx', index=False)

start the next python script that creates/edits the html file:

subprocess.call(["python", "H:\python codes\excel\planner software\make-website.py"])    

• The script to read the excel, opens the html, edits the html uses the same "read" reference for excel as above and uses this one to open the html:

Open html:

open("H:\python codes\excel\planner software\calendar.html", "w") as f:

The goal:
The goal is to automate the first script and let it run everyday at a specific hour. It should be done if the user is logged in or logged out. It shouldn't matter. I try to do this with windows task scheduler.

What I tried:

I created a task within the task scheduler. I selected the box to run the task no matter the login status of the user. Within Action is chose for "start program", for program/script i put in the storage path "\storage\Users\lambra\python codes\excel\planner software\planner.py" and in the start in field, i put "\storage\Users\lambra\python codes\excel\planner software"

I did this following other stackoverflow posts and google findings. I tried it with drive letters as well. Sometimes my settings where setup that the task scheduler gave an error that it could not run the task. However with these settings, it says it ran the task but I notice the HTML file is not changed. In task scheduler I can see that the task is started (event ID 100), the editing is started (ID 200) and I get a line with

> task started by user (ID 110)

I already tried to change all permissions to allow everything for those files. When running the python script manually or even with a batch file, it works, but scheduling it, does not.

I had this same issue once, and came up with a workaround since it seems TS is not python friendly.
Now what I use Task Scheduler to run a .bat file that executes the python programs one after the other.

The file should look like this:

run_from_TS.bat

:: Open the disk where you store your program
D:
:: Open the project folder for your python scripts
cd "D:/path/to/project"
:: Open the python script you want to execute using the correct python instance
"D:\path\to\project\Environment\Scripts\python.exe" "D:\path\to\script\to\run"

Please note that i use "/" and "".

On the TS the options are as follows:
General: Run with highest privileges is DISABLED.
Triggers: Whenever you want, but make sure Status is Enabled.
Actions: Start a program (path to your .bat file following this example and using "": "D:\the\path\to\file.bat").
Conditions: Your choice here.
Settings: Your choice here. I recommend enabling "Allow task to be run on demand".

PD:
I would also recommand you to familiarize yourself on how .bat and TS work (togheter) before running your scripts. Remember you can enable the task to be run on demand on the TS settings as mentioned above and test if it is not working from the TS part or the .bat part.

PD 2 (my TS config):