Call a python function from vba

Question

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.

score 2 · Answer 1 · edited May 23 '17 at 11:50

2

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(...).

edited May 23 '17 at 11:50

Community

answered Jan 15 '16 at 22:55

Laurent LAPORTE

Thanks, in my Python script, I have different defined functions, I just don't know how to call one of those defined functions within vba. – Bee Jan 17 '16 at 02:08

1 Answers1