Written by Allen Wyatt (last updated January 8, 2025)
This tip applies to Word 2007, 2010, 2013, 2016, 2019, and 2021
Word allows you to maintain a list of the most-recently used (MRU) files. This list can record the names of the most recently opened and edited within Word. You can see the MRU list by clicking the Office button (in Word 2007), clicking the File tab of the ribbon and then Recent (in Word 2010), or clicking the File tab of the ribbon and then Open (in later versions of Word).
If you want to grab the names of the MRU files and insert those names in a document, you can use the following VBA macro:
Sub MostRecent() Dim r as RecentFile For Each r in RecentFiles Selection.TypeText Text:=r.Name Selection.TypeParagraph Next r End Sub
The macro accesses each member of the RecentFiles collection, adding the name of each member to the document.
Note:
WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (13360) applies to Microsoft Word 2007, 2010, 2013, 2016, 2019, and 2021. You can find a version of this tip for the older menu interface of Word here: Grabbing the MRU List.
Learning Made Easy! Quickly teach yourself how to format, publish, and share your content using Word 2013. With Step by Step, you set the pace, building and practicing the skills you need, just when you need them! Check out Microsoft Word 2013 Step by Step today!
Save a document for the first time, and Word helpfully suggests a filename you can use or change. If you want this ...
Discover MoreWant to get rid of any properties you've created for a document? You can do so by using the short macro described in this ...
Discover MoreAfter merging the information from a data source into a document, you may decide that you only want to open the merge ...
Discover MoreFREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."
2025-01-08 10:19:49
Beepee
Hi.
I'm still a bit of a novice when it comes to Word VBA.
I've used the above macro (Word 2019) - just fine, thank you (again) Allen.
I started with a long list (50 items) and discovered I can reduce this in the File>Options>Advanced>Display>Show this number of Recent Documents...
I also modified macro to list files each with a number:
Sub MostRecent() 'list recently used Files in current document
Dim r As RecentFile
Dim n As Integer
n = 1
For Each r In RecentFiles
Selection.TypeText Text:=n & " "
Selection.TypeText Text:=r.Name
Selection.TypeParagraph
n = n + 1
Next r
End Sub
What would be really handy is to add the associated date after the file name - but I've been unable to achieve this!
Any help would be much appreciated.
Thanks
B
Got a version of Word that uses the ribbon interface (Word 2007 or later)? This site is for you! If you use an earlier version of Word, visit our WordTips site focusing on the menu interface.
Visit the WordTips channel on YouTube
FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2025 Sharon Parq Associates, Inc.
Comments