Application.RecentFiles Property

Returns a RecentFiles collection that represents the most recently accessed files.

Syntax

expression.RecentFiles

expression   A variable that represents an Application object.

Remarks

For information about returning a single member of a collection, see Returning an Object from a Collection.

Example

This example opens the first item in the RecentFiles collection (the first document name listed on the File menu).

  If RecentFiles.Count >= 1 Then RecentFiles(1).Open

This example displays the name of each file in the RecentFiles collection.

  For Each rFile In RecentFiles
    MsgBox rFile.Name
Next rFile

See Also

• Application Object
• Application Object Members