RecentFile Object

Microsoft Excel Visual Basic

ApplicationRecentFiles
RecentFile

Represents a file in the list of recently used files. The RecentFile object is a member of the RecentFiles collection.

Using the RecentFile Object

Use RecentFiles(index), where index is the file number, to return a RecentFile object. The following example opens file two in the list of recently used files.

Application.RecentFiles(2).Open