Is there a solution to change the recentfilelist programmatically

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Is there a solution to change the recentfilelist programmatically

FAQ

Thread Tools

Display Modes

11-20-2014, 12:52 PM

charlesdh

Windows 7 32bit Is there a solution to change the recentfilelist programmatically

Office 2010 32bit

Expert

Join Date: Apr 2014

Location: Mississippi

Posts: 382

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

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Creating Event Handlers Programmatically	pluviosilla	Word VBA	4	11-06-2014 05:36 PM
Adding macro to normal.dotm programmatically	etippelt	Word VBA	6	04-08-2013 05:55 PM
Programmatically convert Office documents to PDF from C#	hemaneelagiri	Office	0	10-21-2011 06:07 AM
outlook programmatically read an attachment into byte array	chriskaza81	Outlook	0	11-19-2010 01:03 AM
Programmatically changing folder item selection	Richard Cook	Outlook	0	02-09-2007 02:25 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:55 AM.