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
|