Call python from VBA , script does not run

Question

I have an input file in Excel which is used in a Python script solver.py. When I run the Python script, the outputs are printed in a different .xlsx file. I want to call the python script directly from the input file. I use the following code:

Dim objShell As Object
Dim PythonExe, PythonScript As String
Set objShell = VBA.CreateObject("Wscript.Shell")   

PythonExe = "C:*PATH*\Anaconda3\python.exe"
PythonScript = "C:*OTHERPATH*\solver.py"

objShell.Exec PythonExe & " " & PythonScript

ActiveWorkbook.UpdateLink Name:= _
        "C:*OTHERPATH*\output.xlsx", Type:= _
        xlExcelLinks

The last line is irrelevant, but when I manually change the output file and call the code, the values are updated. So I know for sure that this code runs completely. However, solver.py is never called. I see the black screen flashing shortly, but that's it, no calculations are made.

Why is solver.py not called? Is there any way to check what goes wrong, since I get no error messages?

Are you sure that user has access to the path under `C:` drive? — Maciej Los
– Maciej Los, Commented Jun 17, 2021 at 10:02
@MaciejLos These are my own files. I can open the python.exe manually. The files solver.py, output.xlsx and input.xslx with the VBA code are in the same folder. So I'm pretty sure the access isn't the problem? — Runner
– Runner, Commented Jun 17, 2021 at 10:06
I'd suggest to add error handler in your VBA code to find out what is causing the problem. — Maciej Los
– Maciej Los, Commented Jun 17, 2021 at 10:09

Runner · Accepted Answer · 2021-06-17 14:06:35Z

1

Found the answer myself. I ran the following in the command prompt:

"C:*PATH*\Anaconda3\python.exe" "C:*OTHERPATH*\solver.py"

I found out that there were issues with importing pandas since numpy did not have the correct version. Running from within Spyder did not have this problem. Reinstalling both pandas and numpy fixed my problem.

answered Jun 17, 2021 at 14:06

Runner

214 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

ClaudioM Over a year ago

You made my day man! Thanks for the hint! I had the same issue too from excel, I'll remember to install pandas separately from now on!

Collectives™ on Stack Overflow

Call python from VBA , script does not run

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related