Ive created a custom report template in SIMS that after generating my report copies the data into another spreadsheet. The problem is that after running (which it does fine) I am left with two extra copies of excel open in the background that I don't really need.
Is there a way in VBA to close down other copies of excel? I've seen the code to colse the activeworkbook but that's the one I need open. It's the other's I need to close.