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?

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)


MikeH2 wrote:
>
> 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

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?