Calling python script from VBA

Question

There seems to be a lot of threads on this one and they all point to this solution:

Function call_py()

Dim rv As Variant
Const pypath = "C:\Users\user\AppData\Local\Programs\Python\Python36-32\python.exe "
Const scriptpath = "c:\Users\user\Desktop\test.py"

    rv = Shell(pypath & scriptpath, vbNormalFocus)


End Function

or something similar. All this does though is make a shell pop up and disappear without executing the script. What am I doing wrong?

P.

If I were you, I would write those commands in a batch file, and then run the batch file. — Tehscript
– Tehscript, Commented Aug 3, 2017 at 16:21

Tehscript · Accepted Answer · 2017-08-03 16:26:31Z

1

Try this:

Sub bat()
Dim batch, fso As Object
Dim path As String
path = "c:\Users\user\Desktop\"

Set fso = CreateObject("Scripting.FileSystemObject")
Set batch = fso.CreateTextFile(path & "python.bat", True)
batch.writeline "cd " & path
batch.writeline "python test.py"
batch.Close

Shell path & "python.bat", 1
End Sub

answered Aug 3, 2017 at 16:26

Tehscript

2,5562 gold badges15 silver badges24 bronze badges

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

1 Comment

SIM Over a year ago

Awesome Tehscript!! I've been looking for this.

Florent B. · Accepted Answer · 2017-08-03 16:37:15Z

0

Add the argument "-i" to inspect the execution.

The console will remain opened and you'll be able to see why it's not working as expected :

Shell "python -i " & scriptpath

And make sure that the paths are quoted if they contain a space character.

answered Aug 3, 2017 at 16:37

Florent B.

42.7k7 gold badges92 silver badges105 bronze badges

1 Comment

Paul Over a year ago

Ha ha! This was going to be my next question! Thanks.

Collectives™ on Stack Overflow

Calling python script from VBA

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related