![close vba project excel close vba project excel](https://sec.ch9.ms/ch9/f606/3c7b0bb0-4b52-4f01-8ba7-6f81d73af606/Collab365RafaAnsino_960.jpg)
![close vba project excel close vba project excel](https://www.got-it.ai/solutions/excel-chat/wp-content/uploads/2019/06/Screen-Shot-2019-06-23-at-11.52.36.png)
#CLOSE VBA PROJECT EXCEL PC#
Set WkBk = Nothing 'removes the file from the project editor on my PC but not on client Set WkBk = Workbooks.Open("C:\UserName\FilePath\FileName.xlsx") I believe the issue may be related to SharePoint.
#CLOSE VBA PROJECT EXCEL CODE#
The simple code ('set wkbk = nothing') will eliminate the problem on my PC however, this will not be the case for my client's VBA Project Editor eventually, this creates multiple replicas of the same file names eventually leading to issues and even crashes. I have a problem with files "hanging" or "ghosting" in the VBA Project Explorer window after close event. I developed code for my client who uses SharePoint to share files within their team. 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: