Run Python Code with Excel VBA |
In this video, I'll show you how to run a python code using Excel VBA.
The VBA code below is not mine. I found it in dozens and dozens of google searches and it's the same code. Remember to change the two variables inside the """ """"
#Python #ExcelVBA
Follow me on Twitter and Github @bjone6.
====================================
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 = """ """
PythonScriptPath = """ """
objShell.Run PythonExePath & PythonScriptPath
End Sub
Watch video Run Python Code with Excel VBA | online without registration, duration hours minute second in high quality. This video was added by user Brandon Jacobson (Jacobson Enterprises) 21 September 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 15,083 once and liked it 139 people.