Let the user decide the paths when calling RunFrozenPython or RunPython
I'm running the .exe files (frozen .py files) from another path than the workbook, I can't seem to customize the directory without updating the imported xlwings.bas file. Customizing the .bas file is a bad idea as everything may brake down when xlwings is updated.
The reason why the executable (and other compiled library files) are in a separate directory is that the libraries take a lot of space (Pandas, Numpy, Scipy), and having multiple Excel tools using the same libraries take a lot of space (400 MB) x tools froozen, if every library is copied multiple times. When I have all the libraries in just one directory it takes "only" 400 MB.
Thus my suggestion is that the the VBA function would be:
RunPython("PythonCommand As String", optional ByRef PYTHONWIN As String="", optional ByRef PYTHONMAC As String, optional ByRef PYTHON_FROZEN As String, optional ByRef PYTHONPATH As String)
RunFrozenPython(Executable As String,optional ByRef PYTHONMAC As String, optional ByRef PYTHONFROZEN As String, optional ByRef PYTHONPATH As String)
and these arguments would then be considered when setting up the paths
needs to be discussed on GH issues.