Closing EXCEL instances with MS Access VBA...
Posted on 2013-11-06
I've tried half a dozen routines I've found on the net for 'killing' EXCEL from within VBA. Most can kill instances that I started myself MANUALLY by opening a spreadsheet from my Desktop (Win 7 64-bit, but Office of course is 32-bit).
My code within the Access program actually then OPENS 2 spreadsheets and modifies one of them extensively. It seems that it is THIS VERY INSTANCE of Excel that gets 'stuck' in memory, even though I use best-practices for late-binding and Excel object manipulation, etc, etc.
If I EXIT entirely from the Access program, that instance of Excel WILL get closed. But I hate to ask my users to exit the entire program every time they process a set of 2 spreadsheets, as they have dozens of sets to process.
Any ideas would be appreciated.