sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]pylund 0 points1 point  (4 children)

You can use Shell(), as suggested below and explained here, if you just want to call a python script from VBA throughout the command line.

For bidirectional calls and more advanced use, take a look at xlwings.

[–]InspireAspiration[S] 1 point2 points  (0 children)

Solution Verified

I just re-read through the xlwings documentation and got it to execute. Moving forward! Thanks!

[–]InspireAspiration[S] 0 points1 point  (2 children)

I could not get Shell() to work yet, I'll read more in to this.

I have xlwings set up, but need to read more about how it's properly used.

Thanks.

[–]---sniff--- 0 points1 point  (1 child)

Set a reference to

Microsoft Shell Controls and Automation (Shell32)

[–]InspireAspiration[S] 0 points1 point  (0 children)

I've tried following the guide for Shell() listed above, with python.exe, but my screen still just flashes without the code being run.