I don't usually code in VBA, but need to create a VBA macro from which I can run a .bat file that executes a python script. I have been able to do this, however since the program runs outside the excel environment, I need to determine when the .bat file has completed, and return a message to the excel environment. This is what I have so far:
Shell ("CMD.EXE /c c:\IndexTrader\run_file\index_trader.bat")
Once the above .bat file runs, how can I print a message to excel environment that shows that the .bat file has executed. If I run sequential code after the .bat file command (see code above), since the .bat file is executed outside the excel environment, any sequential code that is run after this command will run even though the .bat file has not completed. Is there a way to output a message or parameter that shows that the .bat file has executed, and then only execute any sequential code in VBA.