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 22.214.171.12436 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.