View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] pfsardella@yahoo.com.nospam is offline
external usenet poster
 
Posts: 172
Default Add file to Recent File List

Use the Add method for the RecentFiles Collection Object
From VBE help example :

Application.RecentFiles.Add Name:="Oscar.xls"

HTH
Paul
--------------------------------------------------------------------------------------------------------------
Be advised to back up your WorkBook before attempting to make changes.
--------------------------------------------------------------------------------------------------------------

This is how to add the current file to the Recent File List in Word:

Sub AddCurrentFileToMRU()
RecentFiles.Add Document:=ActiveDocument.FullName
End Sub

I can't figure out how to do it in Excel. Any ideas?


TIA,

Andy