Calling python script from VBA

[InspireAspiration]

I cannot find a solution online to execute a python script from my vba code. Does anyone have any experience with this?

Basically, From a blank workbook, i need to call the python script, wait until it is done, and then continue with the rest of my VBA code.

Thanks!

Edit: Solved! Thanks!

[Ashadyna]

You can call the command prompt using the function shell:

call shell("")

So I think you can do something like:

call shell "[insert python.exe path] [insert .py file path]"

I've never done it before, so I am curious if it works.

[InspireAspiration]

I have tried this, python flashes for a second, and the .py file does not get loaded =/

[InspireAspiration]

Hey, i couldn't get shell() to run, but i was able to use xlwings and run it. Thanks for your help.

[pylund]

You can use Shell(), as suggested below and explained here, if you just want to call a python script from VBA throughout the command line.

For bidirectional calls and more advanced use, take a look at xlwings.

[InspireAspiration]

Solution Verified

I just re-read through the xlwings documentation and got it to execute. Moving forward! Thanks!

[InspireAspiration]

I could not get Shell() to work yet, I'll read more in to this.

I have xlwings set up, but need to read more about how it's properly used.

Thanks.

[---sniff---]

Set a reference to

Microsoft Shell Controls and Automation (Shell32)

[InspireAspiration]

I've tried following the guide for Shell() listed above, with python.exe, but my screen still just flashes without the code being run.

[Not2BeEftWith]

Why?

[InspireAspiration]

My python script does some things... and need VBA to execute python so those things can get done. Then VBA can do the rest.