How can I call python program from VBA?

Question

Just as the title goes.

I have a python program which processes some data file I downloaded from email.

I am writing a vba script which can download the email attachments and execute the python program to process the email attachments, such that I can automate my daily job.

Any idea?

David Zemens · Accepted Answer · 2015-04-01 16:29:41Z

4

One way to do that is to turn your Python code into a COM Server and then access it like any other COM object. This chapter from Python Programming on Win32 shows how simple it can be. The rest of the chapter gets into a lot of technical details that are probably not necessary for your application. Just turn your Python code into a class, expose one method for the VBA to call it, and that should do the trick.

edited Apr 1, 2015 at 16:29

David Zemens

53.8k12 gold badges86 silver badges132 bronze badges

answered Nov 1, 2011 at 7:15

Michael Dillon

32.5k7 gold badges76 silver badges107 bronze badges

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

Comments

shahkalpesh · Accepted Answer · 2011-11-01 07:11:22Z

1

Shell "path to my python exe"

I am sorry, I haven't used python enough.
Lets say, you want to run .pyc file, it could be

Shell "path to python.exe argumentOfPYCFilePath"

answered Nov 1, 2011 at 7:11

shahkalpesh

33.6k4 gold badges66 silver badges89 bronze badges

2 Comments

lamwaiman1988 Over a year ago

Doesn't work. Do you realize we need to type "python somecode.py" to make a python code run in cmd?

shahkalpesh Over a year ago

Yes. Make sure that Python.exe is in your path & give the full path in case of any doubts. For e.g. c:\Python30\Python.exe someargument

Collectives™ on Stack Overflow

How can I call python program from VBA?

2 Answers 2

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related