Skip to Content
Former Member
Mar 06, 2014 at 12:35 PM

Closed Workbooks still appear to be open in VBE / memory issues


Dear fellow users,

I encounter a problem when using macros in an Excel Workbook to access Analysis functions in order to refresh datasources, set filters etc.

After closing the workbook in Excel via File -> Close or clicking the "X" in its window, the Workbook is still available in the Visual Basic Editor.

If I have several files open, I will get memory issues, as the supposedly closed files still seem to take up (quite a lot of) memory.

I use AO with Excel 2010 32bit.

Any suggestions? Thanks in advance!

Please see attaced image. I have one open file, I close it, but is still visible in the VBE.

After unloading the Analysis Com-AddIn the file is gone, Memory is freed.