Link to home
Create AccountLog in
Visual Basic Classic

Visual Basic Classic

--

Questions

--

Followers

Top Experts

Avatar of WeThotUWasAToad
WeThotUWasAToad

Modify the Recent Document list in Office 2010 to not include file directories
Hello,

Is there a way to modify the Recent Workbook list in Excel (2010) so that only the filename is displayed (ie not the directory) for each file?

The following four screenshots are from Google images and, I think, correctly display the Recent Workbook list (File > Recent or File > Open) as it appeared in the Excel version listed:

Excel 2007
User generated image
Excel 2010
User generated image
Excel 2013
User generated image
Excel 2016
User generated image
As shown above, the Recent Document list (for version 2007 and earlier) displayed as a single line for each file and did not include a second line showing the directory as became the format beginning with Office 2010.

I suspect this change came about, like many others, as part of Microsoft's efforts to make their application interfaces more compatible with touchscreens. However, in addition to being superfluous (since a file's directory can easily be seen by mousing over the filename), it was not a positive change (imo) for mouse users because it lessens the efficient utilization of screen space.

Is there a way, using VBA or some other means (eg AutoHotkey), to eliminate the directory lines and display a more compact list of recent files as in the past?

By the way, I continue to use Office 2010 (for several reasons similar to the above) so that is the version I am particularly interested in.

Thanks

Zero AI Policy

We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.


Avatar of Fabrice LambertFabrice Lambert🇫🇷

I don't think it is doable, as the list is managed by Excel, and VBA have no means to interact with it.

I think the change is a positive one as you can see at a glace, without having to move the mouse, which file is which when there are 2 files with the same name.

ASKER CERTIFIED SOLUTION
Avatar of Joe WinogradJoe Winograd🇺🇸

Link to home
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
Create Account

Avatar of WeThotUWasAToadWeThotUWasAToad

ASKER

Thanks Joe, that's a great workaround.

Reward 1Reward 2Reward 3Reward 4Reward 5Reward 6

EARN REWARDS FOR ASKING, ANSWERING, AND MORE.

Earn free swag for participating on the platform.


Avatar of Joe WinogradJoe Winograd🇺🇸

You're welcome, Steve. I'm glad that's an acceptable workaround for you. Regards, Joe
Visual Basic Classic

Visual Basic Classic

--

Questions

--

Followers

Top Experts

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.