Excel Automation With Python 

Thanks brother! :)

Take a look at the channel. I have uploaded exactly the video you are looking for a couple of days ago.

Yes, you could use VBA for this: Sub RunPythonScript() Dim objShell As Object Dim PythonExePath as String, PythonScriptPath As String ActiveWorkbook.Save ChDir ActiveWorkbook.Path Set objShell = VBA.CreateObject("Wscript.Shell") 'PythonExePath = """ Insert Path to Python EXE here """ 'PythonScriptPath = """ Insert Path to Python SCRIPT here """ objShell.Run PythonExePath & PythonScriptPath End Sub

@@CodingIsFun Thx a lot ! Appreciate that (:

:)

VBA is a programming language. Excel isn't. But yes VBA is a joke to me.

Lol🤣

VBA has not been updated since 1997 (except for support for new Excel feautures). VBA lacks a lot behind when compared to modern programming languages, for example VBA cannot extend classes. The error handling is made by using labels, which makes "spaghetti" code. And so on. So yeah agree VBA is fun, but kinda also a joke. Even Microsoft is currently moving to Python as the default language behind Office. The founder of Python was hired by Microsoft in 2020. Also: VBA only works on Windows and Mac - no Linux. And using external refs and or ActiveX, makes it Windows specific. Not really what you want in a modern IT environment.

Give it a try ^^

@@NeuralNine I would love to but I am still a newbie in coding😅😅

^^

👏🏻

Im so sorry.

Well, Linux supports XLSX files as well ^^

Just use LibreOffice or OpenOffice. they both support Excel formats/