How to get the return value or output of the shell function in VBA?

[woshichuanqilz]

I want to use shell to run a python script and get the return value(or output will be fine) from the python script. How to make that happen ?

[Leith Ross]

Hello woshichuanqilz,

Before you execute the Shell command, Python must be installed on your machine. If it is installed and you have added the executable path to your Windows Environmental variables you can use Python.exe along with the path to the script file. If not you must include the full path to Python.exe on your machine. Python.exe will open a console window when the script runs. You will be able to see the results in this window.

[woshichuanqilz]

I want to interact with the python, for example I pass some parameters to python script from vba and get the result from python script, you know that the python is more handy than vba it's a good choice to make python to do some task for vba, so is there a way to make vba get the result from python ?

[buran]

do you consider using xlwings https://www.xlwings.org?