Add file to Recent File List

[Andy]

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

 

[pfsardella]

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

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

HTH
Paul

 

[Andy]

Hadn't been able to find anything in Help that had
"Application.RecentFiles" and "Add", which is why I came here <g>.

So I ended up with

Application.RecentFiles.Add Name:=ActiveWorkbook.FullName

Which worked fine.

Thanks Paul


Andy

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

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

HTH
Paul

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 >> >>