CODEWITHSUNDEEP
pythonvba
Bee
Bee

Reputation: 31

Call a python function from vba

I am trying to call a python function in a .py file in VBA.

I use this command to open the python shell :

Pathctrl = "C:\users\test\Desktop"
ChDir Pathctrl
Call Shell(Pathctrl & "\anaconda_python.bat ", vbNormalFocus)

I don't know how to write a VBA command to run a specific function within a python shell.

Upvotes: 3

Views: 953

Answers (1)

Laurent LAPORTE
Laurent LAPORTE

Reputation: 22952

This is a VBA question (and not related to Python).

According to @Ripster, in Execute a command in command prompt using excel VBA, you can call a Script with Call Shell(...).

Upvotes: 2

Related Questions