0

Is it possible to execute a python script with Excel VBA and get a response from the python script?

So I want my VBA script to execute a python code which can return a string to the VBA script so it can use it.

Pᴇʜ
  • 45,553
  • 9
  • 41
  • 62
Programming Maniac
  • 77
  • 1
  • 9
  • 2
    Already quite a few similar questions here: https://www.google.com/search?q=VBA+execute+python+script+get+response+site:stackoverflow.com – Tim Williams May 13 '19 at 23:36
  • I know how to execute a python script with Excel VBA, but I want to be able to get a response from the python script. – Programming Maniac May 13 '19 at 23:37
  • 1
    See Brian's answer here: https://stackoverflow.com/questions/2784367/capture-output-value-from-a-shell-command-in-vba – Tim Williams May 13 '19 at 23:45
  • Use a Python class with COM attributes, aka Python Gateway class , https://exceldevelopmentplatform.blogspot.com/2018/01/calling-python-class-using-vba-with-com.html – S Meaden Jun 08 '19 at 19:02

0 Answers0