VBA Closing External Application

[mkron]

Hello,

I have a macro designed to open an external application (non-microsoft), do a task, and I would like it to close after because it will be doing this in a loop and it could open 10+ windows. Is there a way to close an an application like Shell() to open?

Thanks for the help!
-MK

 

[Carpaccio]

Hi mkron

Check out this thread - it may be the answer:
https://www.mrexcel.com/forum/excel...window-through-visual-basic-applications.html

HTH
Alan

 

[mkron]

Hey Alan,

Thanks for the link! I was able to send the F10 key to select the "File" in the main bar and the just arrow down to exit and hit enter!

-MK