How To Execute A Python Script From Excel Using VBA | Step-by-Step Tutorial [EASY]

𝗗𝗘𝗦𝗖𝗥𝗜𝗣𝗧𝗜𝗢𝗡
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
In this tutorial, I will show you, how to execute a Python script from Excel by using VBA.
If you do not have any experience in VBA, do not worry. To run a python script in VBA is very easy and I will explain every step.

Download the Excel File (incl. VBA code) & the Python Script of this video here [Google Drive]:

To execute a Python script from Excel using different virtual environments [which also works on macOS], feel free to check out the following tutorial:

🚩 Please find below the VBA Code:
_____________________________________________________________

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
_____________________________________________________________

𝗧𝗢𝗢𝗟𝗦 𝗔𝗡𝗗 𝗥𝗘𝗦𝗢𝗨𝗥𝗖𝗘𝗦
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀

𝗖𝗢𝗡𝗡𝗘𝗖𝗧 𝗪𝗜𝗧𝗛 𝗠𝗘
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀

☕ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲?

[eltonm.t.]

*Very useful teaching! One could also use Excel VBA to run any kind of Python script to do different things, even things that are not supposed to return to Excel! Great!*

[tunkyi]

Your channel is very underrated. I have subscribed now to motivate you. waiting for more!

[nabilhelmy]

A very nice idea to link vba & python codes. Thanks.

[gustavomsantana]

Thank you for the video! I followed the instructions, but the button in excel only open the Command Prompt (cmd), that instantaneously closes, and nothing more happens. Does anyone know what can be happening?

[jackychan]

Great explanation and not to complicated 👍🏾

[suhardisjahrial]

What I like about your videos is the to-the-point explanation -- kein Quatsch.

[malcolmmckean]

Great Video! Was wondering if there was way to run the VBA program when you save the excel file? Essentially what I want to do is run a python script whenever a change is made to the spreadsheet.

[replikvltyoutube]

Excell is the best GUI development framework :)

[leandrosantoscosta]

you are the best, pity I know only basic English, but you is very good, congratulations.

[maryjena]

Could you please also explain .. how to execute Javascript from excel too..

[santhoshreddykesavareddy]

Wow! Super useful Thanks! much :). This will really help for everyday morning tasks. I have a question.. here we're doing the python stuff outside excel which means if we want to share, I'm assuming we have to share the python script as well which is not recommended. Is there a way to write python right inside excel so that it will be easy to share and run anywhere ?. Thank you

[hagataaersadaginting]

This is a great video! one question though, how can we return feedback if there is an error on the script's run, without having to check into the terminal?

[peterquery]

Tahnk you for the Video, its great !

I have a question regarding "PythonExePath". In your video, you use a specific path "C:\Users\Name...". But can we use instead of a specific path, for example environ("python") ? Because i want to build a general tool (.exe) which can be used from different users.

[manishmarch]

Great tutorial!
But rather than writing a Macro, I tried to add the hyperlink in the excel sheet. For small program(without external lib) it works well by opening Command Prompt, but it fails to run if I include Panda library. Do you know how can I resolve this using just the hyperlink?

[SaulEduardoo]

Hi Sven, in order to make the code worked on my laptop I had to make some changes, I added the openpyxl module to the requirements and I used the chdir as this os.chdir("Current Path where the files are contained")

Just after that, the code ran well. The problem was that wasn't generating the .html file because there was an error with some "traceback" after that the interpreter showed some folders that there were problems executing the

[lionatticus]

Great video! Thank you! If you wanted someone on another computer to be able to run this, how about you go about that? Send a zipped file with Python installed with the folder directory or would there be code that could locate the python path…?

[slickbuyers]

great stuff @coding is fun, learning a lot of things from this channel, one question can we make it a lil bit more easy like, we dont have to save each time and we dont have to press any button to execute the program, its like we put any value on any particular cell and press enter to execute. i need this real time update feature from excel for a project, atleast tell me what to research. thank you

[pauladdison]

Awesome channel and learning so much, however this is driving me buts. I am getting Run time Error 76 Path not found when clicking the button. Ive checked urls multiple times and they are correct. Ive also been into settings and enabled all macro settings. Now at a complete loss.

[donaldcoffin]

Thanks for such an excellent and easy-to-follow presentation. I have a project that I need to call a Python module from a VBA function and then return the results. How do I pass an argument and obtain a result?

[bala]

Thankyou so much, one doubt, do we need to do pip install xlwings to connect python from Excel?