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.

Community · Accepted Answer · 2017-05-23 11:50:41Z

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

CommunityBot

11 silver badge

answered Jan 15, 2016 at 22:55

Laurent LAPORTE

23.2k7 gold badges64 silver badges111 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

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.