VBA running python code

[Ged Salter]

I am trying to have a vba which will run a python code. Nothing seems to work.

This is what I have so far

Sub RunPythonScript()
'Procedure to run a Python Script in a VBA Procedure
 
    'Declaration
    Dim objShell As Object 'For the Shell
    Dim Pythonexe, PythonScript As String
     
    'Create the Shell Object
    Set objShell = VBA.CreateObject("Wscript.Shell")
     
    Pythonexe = """C:\Users\61458\Desktop\TEST\Windows32.exe\crawl.exe """ 'path of the crawl.exe
   
     
    'Run your Python script
    objShell.Run Pythonexe 'two arguments
 
    'Free variables for memory
     Set objShell = Nothing
     
End Sub

hopefully someone can help

Thank you in advance

[6StringJazzer]

First I would get rid of the inner quotes on the path. They are not needed when you are using a String variable for the argument

Pythonexe = "C:\Users\61458\Desktop\TEST\Windows32.exe\crawl.exe" 'path of the crawl.exe

Also you declare but never use variable PythonScript.

Alternative method:

Sub RunPythonScript()
'Procedure to run a Python Script in a VBA Procedure
     
    'Run your Python script
    Shell("C:\Users\61458\Desktop\TEST\Windows32.exe\crawl.exe", 1)
     
End Sub

[Ged Salter]

sorry for late reply. It did not work. Nothing happened

[6StringJazzer]

What happens if you enter that same path into a cmd window?