Automate Python Script Execution in Colab

I need assistance with my Excel VBA and Python integration. I can open a Colab Notebook from VBA, but I'm having trouble getting the code to execute automatically upon opening the Notebook.
VBA-code:
Sub StartColabScript()
Dim colabLink As String
colabLink = "https://colab.research.google.com/drive/1a6231spJHCQ85SIoQBoBUfxIOzqhIDar"
ThisWorkbook.FollowHyperlink colabLink
End Sub
I cant get this code to run my Python-script.

I also tried:
# Add code to Colab Notebook !python /path/to/your_script.py
!python https://colab.research.google.com/drive/1a6231spJHCQ85SIoQBoBUfxIOzqhIDar
(I dont know if the Notebook is called the right way.
The name of my workbook is:
Ny241028Hent33Tickers3Blokke5y
I guess its .py
How do I refer to this workbook from VBA, and how do I get to autoexecute, when called?


Key Requirements:
- I will provide the Python code, I also have working VBA-code.
- The script should run immediately upon opening the Colab Notebook.
- No additional authentication is necessary as I am already logged into my Google Account.

Ideal Skills:
- Proficient in Excel VBA
- Experienced with Python and Google Colab
- Able to troubleshoot and automate script execution

This project is perfect for someone with an understanding of integrating VBA with Python in Google Colab. Your help will save me a lot of time and hassle!