Forum Discussion
YvesAustin
Mar 09, 2021Copper Contributor
Excel VBA closed file remaining in VBA Project Editor
Good morning to all. I am new to this community and turning to you for some help on a topic that I have seen posted in the past but have not found a proper solution for yet: I developed code for my...
- Mar 11, 2021Nikolino, I truly appreciate the time you spent on finding this solution for me. Thank you. I am not sure I understand the proposed solution and where/how/why it would work. I do not have SharePoint myself and am trying to see if it is possible to create a code (or a way to write code/ declare variables) that would remove these "hanging" files (again these files are closed, but remain accessible in the VBA Project Editor). Best. Yves
PawelBuczek
Mar 03, 2023Copper Contributor
For me this was happening only when VB Editor was opened, so it only really affects some of my debugging. Strange and frustrating, but nothing more. Of course if someone usually runs their scripts from VBE then this issue is much worse.