How to: Programmatically list recently used workbook files

The <xref:Microsoft.Office.Interop.Excel._Application.RecentFiles%2A> 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 VSTO Add-in projects for Excel. For more information, see Features available by Office application and project type.

To list recently used workbooks in a range object

  1. Loop through the list of recent files and display the names in cells relative to a Range object.

    Excel.Range rng = this.Application.get_Range("A1");
    for(int i=1; i<=this.Application.RecentFiles.Count; i++)
        rng.get_Offset(i - 1,0).Value2 = this.Application.RecentFiles.get_Item(i).Name;
    Dim rng As Excel.Range = Me.Application.Range("A1")
    Dim i As Integer
    For i = 1 To Me.Application.RecentFiles.Count
        rng.Offset(i - 1, 0).Value2 = Me.Application.RecentFiles(i).Name

See also

Work with workbooks
NamedRange control
Optional parameters in Office solutions