Application.RecentFiles Property (Excel)
Returns a RecentFiles collection that represents the list of recently used files.
Syntax
expression .RecentFiles
expression A variable that represents an Application object.
Example
This example sets the maximum number of files in the list of recently used files to 6.
Application.RecentFiles.Maximum = 6