I'm using VBA on Excel to run a Python script. Here's what my module looks like:
Sub PythonButton()
RetVal = Shell("C:\Python27\python.exe C:\Users\myName\Desktop\test.py", 1)
End Sub
My command window opens up and appears to give some feedback but the window only remains for a split second. How do I get this window to stay open until, say, the user presses a key?