How to: List Recently Used Workbook Files
Applies to |
---|
The information in this topic applies only to the specified Visual Studio Tools for Office projects and versions of Microsoft Office. Project type
Microsoft Office version
For more information, see Features Available by Application and Project Type. |
The RecentFiles property returns a collection that contains the names of all the files that appear in the Microsoft Office Excel list of recently used files. The length of the list varies depending on the number of files the user has selected to retain. You can display the results in a range.
To list recently used workbooks in a range object
Loop through the list of recent files and display the names in cells relative to a Range object.
Dim rng As Excel.Range = Me.Application.Range("A1") Dim i As Integer For i = 1 To Me.Application.RecentFiles.Count rng.Offset(i - 1, 0).Value2 = Me.Application.RecentFiles(i).Name Next
Excel.Range rng = this.Application.get_Range("A1", missing); for(int i=1; i<=this.Application.RecentFiles.Count; i+) { rng.get_Offset(i - 1,0).Value2 = this.Application.RecentFiles.get_Item(i).Name; }
See Also
Tasks
How to: Display a Dialog Box to Open Excel Files
Concepts
The Variable missing and Optional Parameters in Office Solutions