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, duration hours minute second in high quality that is uploaded to the channel Brandon Jacobson (Jacobson Enterprises) 21 September 2021. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 15,083 times and liked it 139 visitors.
