Edit Recent Files in Excel 2010

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
gadsadAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

JohnBusiness Consultant (Owner)Commented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
byundtMechanical EngineerCommented:
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
gadsadAuthor Commented:
thanks to both, it did not helped but is was clear !!!
0
JohnBusiness Consultant (Owner)Commented:
@gadsad  - You are very welcome and I was happy to help.
0
Qlemo"Batchelor", Developer and EE Topic AdvisorCommented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.