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

Hi,
Thx for the video
My code is failing because the script cannot read the excel that is already open. What can I do about it?

top vide, thx for your precious work

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?

Pycharm can be used or not?

Amazing, outstanding, so easy to follow

I am having a problem where the python window flashes and then the excel workbook crashes upon running the VBA code. Has anyone else encountered this error or know of a solution?

I'm trying to run this my python just open and closes within second without running the code can you please let me know what to do in such case

Hi, thanks for this great video ! I have a problem trying to use it : I get this : ModuleNotFoundError: No module named 'plotly' and lines from 4 to 6 in your codes are underligned. Any idea where it comes from ? thank you

Just what I was looking for. I want to replace tkinter and use excel as the interface.

Could it be a problem if one is using python within spyder?

Can something be done to run the terminal in background instead of popping-up every time, when we run the VB command

Hi there. I would like to learn how to pass variables through python functions by using VBA. I am interested in VBA within Arena Simulation Software, so I cannot work with the Excel add-ins. Thanks a lot in advance

Great information.. can you help me how to run this on Mac OS, When i tried this it generates "Activex Components cant create object " Error . Thanks

I‘m wondering how would I enable the functionality, so I can share it with users who use windows pc‘s, as well as Mac’s?

FileNotFoundError: [WinError 2] The system cannot find the file specified: 'C:\\Users\\junxi\\Python\\python39.zip'

hi i get the above error, please advise

pythonexepath is different if using anaconda "where python" not going to give the answer you seek

Can this be done using C#?

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

Hi, thanks for a great video! Which python compilers does this work on? Tried using Jupiter Notebook from Anaconda with no luck.

It doesn't work for me. I get an error" Method 'run' of object 'IWshShell
3' failed." Could you help to figure out what is wrong?

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…?

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

Holy crap!! Thank you soooooo much. This is AWESOME!!!

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.

Great Idea for call python script from Excel file. Thanks :D

what could be the reason of Perimissionerror, VBA code works but when i try to run the script from CMD i get the premissionerror. Python code separately works well too

Hi

Getting run time error ‘429’

ActiveX component Can’t create object

Is there a way to solve this error?

Thanks!!!!!!

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?

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

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

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!

Hi - great lecture
For me when I run python on an xlsm file - the excel file gets corrupted - any ideas?

I need help. I've copied this to the letter, but it still does not work. Here's what is supposed to happen: VBA script fires, triggers Python code, and Python code writes back into the Excel file. From the Python side, it works. I can initiate the Python code, and watch it make changes to the Excel file. However, I want the trigger event to occur inside Excel. As of now, the VBA script fires, the shell flickers, but nothing happens. Can anyone walk me through what is (or more appropriately, isn't) happening?

Hey, what can I do if i want to send the .xlsm file to someone else, who doesnt have the .py file on his Computer?

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 "df=pd.read_excel('Tasks.xlsm')"

Thanks a lot for this great tutorial. Is it possible to run a python.exe file instead of a .py file?? I would want to share my project with others who won't be able to install python in their system. so I converted the .py file to a .exe file. seems like your code is not working for the .exe file.

Hi bro, when i try to use your file (already insert python.exe and your python code), excel notify that error '5', invalid procedure call or argument, how can i fix it ? thanks bro

DIM in Basic is array definition. Why those objects are defined as arrays? Or, may be, I confusing something?

Very usefull!, From within your RunPythonScript, is it possible to check and activate a specific Python virtuel environment module + pip install -r requirements.txt ?

I really appriciate if you can give me a hint, since Im used to work with multiple venv inviroments on my same computer

Very Good! Thank you! Is it possible to add an execution of python script inside an existing macro?

Is python faster than vba?

Hey, great video!

I was wondering if you could help me:
I want to do exactly the same thing you did on this video, but I coded using Anaconda and Jupyter, therefore my file is .ipynb and your vba code did not work for me. Do you have any insight on why it doesnt work?

Really appreciate any help you are able to provide.

Thanks a lot.

Very nice video ! Thanks!

I´m trying to use your code for a project, I also need to run a Script from an excel, but when I run the code of VBA, it does not throw any error, but it dont run my script. after I press the button, i can see a kind of flash, but nothing.

The file that contains the script is a .IPYNB, because im coding in Jupyter, could be this the error?

thanks for your help, I appreciate a lot.

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

Arrrrrlight 😁

Thanks

Very nice video ! Thanks!

I use your code for a little project. But i have a problem. I want to execute a python script from excel using vba. After executing the python script the next vba-makro should start. But my problem is that the makro starts altough the python script is not finished. How can i extend your code that the next makro starts only if the execution of the python script is done?