The RecentFiles collection holds the list of recently modified files, equivalent to the files listed under the Office icon in the left-hand corner of the application. Each RecentFile object represents one of the recently modified files.
RecentFiles has a few attributes besides the typical collection ones. The Maximum property can be used to set or return the maximum number of files that Excel will "remember" modifying. The value can range from 0 to 9. The Add method is used to add a file (with the Name parameter) to the collection.
Was this article helpful?