?
Solved

Edit Recent Files in Excel 2010

Posted on 2014-11-22
5
Medium Priority
?
275 Views
Last Modified: 2014-11-22
I am looking to edit the content of the "recent " file list in Excel 2010 and Word 2010

All recent files starts with \\serverAAA\file1 and I want to change them alltogether to \\serverBBB\file1

I know I can remove the recent file list and create it anew but I have a long list and many Excel users and it would be lice if there is some way to "edit" this file list instead of delete and recreate

thank you
0
Comment
Question by:gadsad
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 97

Accepted Solution

by:
Experienced Member earned 1200 total points
ID: 40459988
That information is buried in the registry and Microsoft does not (in my experience) offer a tool to edit the BackStage List.

Excel-File-Recent-List
0
 
LVL 81

Assisted Solution

by:byundt
byundt earned 800 total points
ID: 40460030
I didn't want to mess up my recent files, so I couldn't test the code--but the following seems to be working in Excel 2013:
Sub RecentFileTool()
Dim rf As RecentFiles
Dim vFiles As Variant
Dim OldRoot As String, NewRoot As String
Dim i As Long, n As Long
OldRoot = "\\serverAAA\"
NewRoot = "\\serverBBB\"
Set rf = Application.RecentFiles
n = rf.Count
ReDim vFiles(1 To n)
For i = 1 To n
    vFiles(i) = Replace(rf(i).Path, OldRoot, NewRoot)
Next
For i = n To 1 Step -1
    rf(i).Delete
Next
For i = 1 To n
    rf.Add vFiles(i)
Next
End Sub

Open in new window

Cheers!

Brad
0
 

Author Closing Comment

by:gadsad
ID: 40460102
thanks to both, it did not helped but is was clear !!!
0
 
LVL 97

Expert Comment

by:Experienced Member
ID: 40460105
@gadsad  - You are very welcome and I was happy to help.
0
 
LVL 70

Expert Comment

by:Qlemo
ID: 40460149
We performed the registry changes as suggested by John, but within the complete registry by a batch file, when switching file servers several times now. Sadly you have to run it against HKCU, or mount all users' hives in registry to be able to work on them.
Remember that there is more than the MRU lists in Excel and Word - Explorer keeps a lot of them, too.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
In a previous video Micro Tutorial here at Experts Exchange (http://www.experts-exchange.com/videos/1358/How-to-get-a-free-trial-of-Office-365-with-the-Office-2016-desktop-applications.html), I explained how to get a free, one-month trial of Office …
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question