Programming Excel with VBA and .NET

Name

Application.RecentFiles([index])

Synopsis

Returns the RecentFiles collection. RecentFiles represents the list of recently used files displayed at the bottom of the File menu. For example, the following code displays the path- and filenames for each file in the Recent Files list:

Sub TestRecentFiles(  )
    Dim f As RecentFile
    For Each f In Application.RecentFiles
        Debug.Print f.Path
    Next
End Sub