Running Python from VBA using xlwings without defining function

Question

I have python programs that use python's xlwings module to communicate with excel. They work great, but I would like to run them using a button from excel. I imported xlwings to VBA and use the RunPython command to do so. That also works great, however the code I use with RunPython is something like:

"from filename import function;function()"

which requires me to make the entire python program a function. This is annoying when I go back to make edits to the python program because every variable is local. Any tips on running the file from RunPython without having to create a function out of it?

Felix Zumstein · Accepted Answer · 2017-08-10 19:57:56Z

3

RunPython basically just does what it says: run python code. So to run a module rather than a single function, you could do: RunPython("import filename").

answered Aug 10, 2017 at 19:57

Felix Zumstein

7,1101 gold badge38 silver badges68 bronze badges

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

Collectives™ on Stack Overflow

Running Python from VBA using xlwings without defining function

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related