Most Frequently Used

New! Excel User Group Now Open @ www.excelusergroup.org, Check It Out!

Menu command

Type

What happens next?

Most Frequently Used (MRU)

This list stores the list of most recently used files for quick access. If you are using the Windows Power Toys program this list may be greyed out and unavailable. It can be set to show any number of recently used files via Tools>Options...>General. The default is 4. In all cases the last file opened or saved will be at the top of the MRU list. If the file is currently open it is shown without the path and when closed the path, or a truncated version depending on length, is shown. (As below)

Sub ShowMRU()
'Dimension variables
Dim rFiles As RecentFile
Dim sFileName As String
Dim x As Long
x = 1
'Iterate the MRU collection
For Each rFiles In Application.RecentFiles
sFileName = Application.RecentFiles(x).Name
'Print it to the debug window
Debug.Print sFileName
x = x + 1
Next rFiles
End Subub

Top