RecentFile and RecentFiles Members
Use the RecentFiles collection to get the list of recently opened files from the Excel File menu. Use the Application object’s RecentFiles method to get a reference to this collection. Use the RecentFile object to open or remove files from this list. The RecentFiles collection and RececentFile object have the following members. Key members (shown in bold) are covered in the following reference section:
|
1 Collection only | |
|---|---|
|
2 Object and collection | |
|
|
Application 2 |
|
Count 1 |
Creator 2 |
|
|
Index |
|
Item 1 |
|
|
|
|
|
Parent 2 |
|
By default, Excel doesn’t add files opened programmatically to the recent file list. To add those files, use the Open method with the AddToMRU argument set to True or use the RecentFiles collection’s Add method.
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access