Thread: [Solved] Do VBA Projects remaining visible in VBAProject window after they are closed matter somehow?
View Single Post
 
Old 10-15-2023, 04:18 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2021
Expert
  
Join Date: Apr 2014
Posts: 873
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
Quote:
Originally Posted by ArviLaanemets View Post
all those ~1000 workbooks are listed as top of this selection list. I.e. any user who will work with this app, will get his/her latest opened workbooks list spammed with those.
Check out Application.RecentFiles.
The single line:
Application.RecentFiles(1).Delete
removes the most recently added recent file entry.
Perhaps you could add this line within each iteration of your loop?
Reply With Quote