How to: Programmatically List Recently Used Workbook Files
The RecentFiles property returns a collection that contains the names of all the files that appear in the Microsoft Office Excel list of recently used files. The length of the list varies depending on the number of files the user has selected to retain. You can display the results in a range.
Applies to: The information in this topic applies to document-level projects and application-level projects for Excel 2013 and Excel 2010. For more information, see Features Available by Office Application and Project Type.
To list recently used workbooks in a range object
Loop through the list of recent files and display the names in cells relative to a Range object.