I am trying to execute a python script from excel macro. I want to keep the command prompt open to see the messages. Right now it gets closed very quickly after the script executes. How can I keep the command prompt open even after the script is executed.
input()at the bottom of the script, but depending on how you are invoking the script from VBA, that might block the VBA program.