VBA Shell function returns Error 91

[arnaud2]

Hi,
I am trying to execute a python script from VBA code and i get this error : “Erreur d’exécution BASIC. ‘91’. Variable d’objet non définie” (sorry, in french).
I am running on Windows an .xlsm workbook built with LibreOffice CALC (intended to be lately used by an MS-Offce Excel user).
I have also : Option VBASupport 1

RC = Shell(pythonPath, vbNormalFocus, param)

no matter what i put in pythonPath, with or without arguments, i get the 91 error
Shell “hello” ’ → 91
Shell(“hello”) ’ → 91

Am i missing a reference somewhere ? an environment variable… ?
Could you help please ?

Version Info:
7.5.2.2 (X86_64) / LibreOffice Community
Build ID: 53bb9681a964705cf672590721dbc85eb4d0c3a2
CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: fr-FR (fr_FR); UI: fr-FR
Calc: threaded

[mikekaganski]

Are you sure that you have not re-defined Shell function in your code? Say, isn’t there somewhere a definition in your code like

Sub Shell(x As Object)
   ...
End Sub

[arnaud2]

Hi,
Not exactly… but you got the point : i had a Shell object lost in the declarations of my function, from some previous attempt by another way.
Thank you so much. Now it works… Ah ! No it does not
Return code is 0, but it has done nothing. I can tell it has found python.exe, but nothing more. I need to get the shell log somehow. Life goes on.
Thanks again.