Search results

Hi Bob, I can't thank you enough. I've spent hours going over the code and searching message boards for the solution. As soon as I added your fix it worked perfectly. Thanks Again!

I have a VBA application in Access that does a lot of spreadsheet manipulation. At the end of the subroutine or function I close the spreadsheet and set all the objects to Nothing. Looking at task manager, as soon as the appliction object is set to Nothing, the Excel instance clears from memory...