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.
Create Custom Apps with VBA! Discover how to extend the capabilities of Office 2013 (Word, Excel, PowerPoint, Outlook, and Access) with VBA programming, using it for writing macros, automating Office applications, and creating custom applications. Check out Mastering VBA for Office 2013 today!
When you save your documents, you can specify that they be saved in a "read-only" format so that they cannot be changed ...
Discover MoreYour macro may need to know if a particular file exists. This is easy to figure out using the Dir command, and even ...
Discover MoreWord allows you to save your documents in a wide variety of formats. If you want to limit the formats that are available, ...
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