Microsoft Office Forums - View Single Post - [Solved] Is there a solution to change the recentfilelist programmatically

charlesdh · 11-20-2014, 12:52 PM

Hi,

Try tis bit of code in the "Thisworksheet" module.
When the user close the workbook it should be save to the specified drive.

Code:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
    
     Application.DisplayAlerts = False
    ActiveWorkbook.Save Filename:="C:\Users\laura\Documents\Excel\ExcelFiles\David.xlsm"
    Application.DisplayAlerts = True
    ActiveWorkbook.Close
End Sub