Hi , I´m trying to call a Python Script (.py file) from my Excel VBA code
I searched on the internet and found that it can be done using Shell function, but it gives me runtime error 5 Invalid procedure call or argument.
![]()
Sub testPython() Dim pyPrgm As String, pyScript As String pyScript = "C:\Users\Desktop\file1.py RetVal = Shell(pyScript, vbMinimizedFocus) End Sub
Bookmarks