RecentFiles Collection Object
From Microsoft Excel Visual Basic
Application
Represents the list of recently used files. Each file is represented by a RecentFile object.
Using the RecentFiles Collection
Use the RecentFiles property to return the RecentFiles collection. The following example sets the maximum number of files in the list of recently used files.
Application.RecentFiles.Maximum = 6