title: VBA project explorer still showing the excel workbooks which are closed by the macro
body: <p>I have created a macro that opens a excel workbook and performs some operations and then at the end it closes the file.The macro is running fine.</p>
  
  <p>Now, when I open my VBA Project explorer in the vba editor. It shows the list of files that have been opened by the macro even though they are closed. How do i remove them from the project explorer window ? why its still showing the excel workbooks, which are already closed ? is there anyway to fix it or its a limitation?</p>