Hi all,
I have a little bit programmed in VBA and created a UserForm with some code.
Unfortunately this solution you can use in Excel2007 only. When I tried it in Word2007 an unintelligible fact appeared. In Word and Excel we have the same RecentFileList to work with, but in Word-VBA you don't have all properties for this object at hand. What did Microsoft think in that case? I really don't know... In Powerpoint you have the same RecentFilesList too, but there is no programming to this object possible.
All you can say to this facts is
I have attached the UserForm file and you can import it into Excel. The code has some comments in German and I tried to translate them...
The solution is working fine by me. You have to mark the new drive where your files now are 'positioned'. Then mark these same files where you want to change the 'old' drive name into the 'new' drivename. Then push 'ausführen'-Button. At the end you have a new RecentFilesList which works with the new items.
Greetings-
Dietrich