Can VBA do this?

[worldwidewall]

Hi

I am trying to use VBA to close all programs that are open except for the excel file that is running the vba.

Thanks

Dave

 

[Scott Huish]

You may be able to work with this:

http://visualbasic.ittoolbox.com/documents/closing-application-through-vba-event-12144

 

[worldwidewall]

HOTPEPPER

I beleive that script requires me to know the name of the application(s) that I need to clsoe which is not ideal. Also, it looks to me like that would step through all the processes running on the computer which I assume are the same as what you see when you run Task Manager and then click processes. If I stop all of those I might be in trouble. I only need to close the active programs, the ones that I can switch between using ALT TAB.

Thanks

Dave

 

[GTO]

Why are you wanting to close everything?

 

[worldwidewall]

GTO

I want to close everything because I have a script that opens a program and does a bunch of stuff and somtimes there is an error and it does not close the program. And then the next time it tries to run there are more errors. But I realize now that I might be able to use the code that hot pepper suggested as I can figure out the names of the executables I need to shutdown.

Thanks

Dave