Add Item to Recenly-Open Files

[MikeH2]

I often use VBA to open files that stay in memory. I'd like to update the
recent-files list sometimes when I do this. How is that possible?

 

[Dave Peterson]

There's a parm you can specify in the workbooks.open command:

Dim w As Workbook
Set w = Workbooks.Open(Filename:="c:\something.xls", addtomru:=True)

 

[Jim Cone]

This post has code I use on my own system.
It also removes items from the recent files list that no longer exist...
http://tinyurl.com/2eumzt

and this has helpful posting tips...
http://www.cpearson.com/excel/newposte.htm
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"MikeH2"
wrote in message
I often use VBA to open files that stay in memory. I'd like to update the
recent-files list sometimes when I do this. How is that possible?