RecentFiles Collection Object

Microsoft Excel Visual Basic

RecentFiles Collection Object

         
Application RecentFiles (RecentFile)

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