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

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

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