![]() |
|
![]() |
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
![]()
It looks like this won't affect the performance, but there is another annoying effect.
Excel (as many other applications) has a feature, where when you want to open a file, you can select from files lately opened with this program. When I run this workbook and process through ~1000 Excel workbooks in folder (without saving there anything), all those ~1000 forkbooks 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. |
#2
|
||||
|
||||
![]() Quote:
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? |
#3
|
|||
|
|||
![]()
It worked. Thanks!
|
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Word 2013, when switching to next window, often opens it as a tiny window | amz | Word | 1 | 04-20-2021 12:25 AM |
How to call a function in VBAProject(PERSONAL.XLSB) | coffent | Excel Programming | 0 | 05-17-2020 11:31 AM |
How to show days remaining | oliboi | Excel | 6 | 01-24-2019 10:29 AM |
Word window empty when opened minimized while Visible is False | qtutorm | Word VBA | 2 | 10-08-2018 09:10 AM |
Time Remaining Progress Bar | teza2k06 | Excel | 1 | 05-13-2014 05:41 AM |