Please refer this tutorial [**www.youtube.com/@SmartBotSphere**\]:
How to call VBA from Python
How to pass parameter from Python to VBA