View Single Post
 
Old 11-20-2014, 10:43 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,374
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

All you can do through the GUI in such situations is to delete the files from the recent files list. That list is maintained in the Windows Registry and, while it's possible to edit the Registry entries programmatically, you could do serious damage to your OS if you get it wrong.

charlesdh: I can't see how your macro is at all relevant to the OP's problem, since it: (a) pre-supposes the file has been opened; and (b) that you know you want to save it to the hard-coded folder. Adding such code to every workbook, especially with hard-coded paths that may be invalidated (e.g. what do you suppose will happen if the path isn't found or the user wants to save the file to a USB drive?) is likely to create a greater problem than it will save. Furthermore, you can't specify a filename with the Save method, so your code wouldn't work anyway.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote