Add Item to Recenly-Open Files

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MikeH2 - 25 Jan 2008 15:37 GMT

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?

Reply to this Message

Dave Peterson - 25 Jan 2008 16:01 GMT

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)

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

Signature

Dave Peterson

Reply to this Message

Jim Cone - 25 Jan 2008 16:19 GMT

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

Signature

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?

Reply to this Message