Forum Discussion
VBA memory does not clear after closing workbook
Hi, I have an issue with the memory in VBA not clearing whenever I close down a workbook. I am using Office 365. This is a rather new issue that I only had for a few weeks. In other words this is...
Pls. try following. It would not solve the issue but may provide some info that may help further (a hit and trial thing) :-
Activate any of the modules of closed workbook which is still appearing in VBA project explorer.
Open immediate window (Ctrl+G).
Check the address of the file containing this module by typing below in the immediate window:-
? ThisWorkbook.FullName
Is it a success or error?
Try the command again by moving/deleting the closed workbook.
(You can also try running a ThisWorkbook.Close sub)
Activate any of the modules of closed workbook which is still appearing in VBA project explorer.
Open immediate window (Ctrl+G).
Check the address of the file containing this module by typing below in the immediate window:-
? ThisWorkbook.FullName
Is it a success or error?
Try the command again by moving/deleting the closed workbook.
(You can also try running a ThisWorkbook.Close sub)
- Hi Again,
Thank you for the help.
I figured out how to roll back to a previous version of Office. That solved the problem. For now at least.
