How do I get a shell to stay open on VBA on Excel?

Question

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?

I'm unsure if you can do Shell("C:\Python27\python.exe C:\Users\myName\Desktop\test.py" && Pause, 1) — QHarr, Jun 05 '18 at 14:01
@QHarr didn't work unfortunately :( but thank you for the suggestion! — secretagentmango, Jun 05 '18 at 14:14
Possible duplicate of [How do I make python to wait for a pressed key](https://stackoverflow.com/questions/983354/how-do-i-make-python-to-wait-for-a-pressed-key) — BruceWayne, Jun 05 '18 at 14:31
@QHarr it just went through and ignored. What I ended up doing instead is using a batch file, and that worked. — secretagentmango, Jun 05 '18 at 15:03

score 1 · Accepted Answer · answered Jun 05 '18 at 15:35

1

I ended up using a batch file with a "pause" in it instead:

Sub PythonButton()

RetVal = Shell("C:\Users\myName\Desktop\start.bat", 1)

End Sub

I let my batch file run the python script instead.

answered Jun 05 '18 at 15:35

secretagentmango

619
2
10
17

How do I get a shell to stay open on VBA on Excel?

1 Answers1