Run Python Script via VBA from different Computers

Question

I want to develop a tool where it is necessary to start a Python script via VBA.

I found the following code on the internet:

Sub RunPythonScript() '''This sub starts the Python script that creates the plots

    Dim objShell As Object
    ActiveWorkbook.Save
    Dim PythonExePath, PythonScriptPath As String

    Set objShell = VBA.CreateObject("Wscript.Shell")
    
    'PythonExePath = """C:\Users\MyName\AppData\Local\Programs\Python\Python38-32\python.exe""" ' 
    PythonScriptPath = "C:\Projects\MYproject\cttdb_plot_creator.py" 
    
    objShell.Run PythonExePath & PythonScriptPath

End Sub

This code works for me. However, when a colleague starts the tool from his computer, it does not work.

I think that I have entered too specific a path for "PythonExePath", namely: C:\Users\MyName\AppData\Local\Programs\Python\Python38-32\python.exe.

Is there a way to enter a path that is more general and works for every user?

Hey, freeflow. Thank you for your comment. But i'm new in coding.....what do you mean with your answer? — HaRez
– HaRez, Commented Mar 15, 2021 at 16:51

Parfait · Accepted Answer · 2021-03-15 21:25:18Z

1

Simply have all users include the python.exe installation folder in their Path environment variable. On Windows which may require admin access, follow:

Control Panel > System and Security > System > Advanced system settings 
 > Environment Variables... > Path > OK > [Add new folder where python.exe resides]

See screenshot dialogs:

Verify with PowerShell ($Env:Path) or CMD Prompt (echo %Path%).

Once done, you can shorten your command line with:

PythonExePath = "python"
PythonScriptPath = "C:\Projects\MYproject\cttdb_plot_creator.py" 
    
objShell.Run PythonExePath & " " & PythonScriptPath

answered Mar 15, 2021 at 21:25

Parfait

108k19 gold badges103 silver badges138 bronze badges

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

2 Comments

HaRez Over a year ago

Thank you very much. This was the solution. I will mark as correct answer.

Parfait Over a year ago

Great to hear and glad to help! I hope screenshots help future readers as simply saying add python to environment Path variable may be formidable for newcomers.

Collectives™ on Stack Overflow

Run Python Script via VBA from different Computers

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related