List of Recent Files

S

Steph

Excel 2003 allows you to view a list of nine of your most recently opened
files. Is there a VBA procedure available that would provide a list of even
more files? For example, could the code code return a list of 50 most recent
files?

I've tried variations of RecentFiles property but seem to be stuck.

Thanks for any help that can be provided.
 
R

Rick Rothstein \(MVP - VB\)

According to the help files, the Maximum property can only be a value from 0
to 9.

Rick
 
N

Nigel

Oops! Apologies I missed that point.

--

Regards,
Nigel
(e-mail address removed)



Rick Rothstein (MVP - VB) said:
True, but the OP asked about Excel 2003.

Rick
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Record Name of Workbook on Close 4
Macro to delete Recent Files list (except those "pinned") - Excel 3
Better MRU list possible via VBA? 7
Most recent file list 1
exporting/saving recent files list 3
How do I delete items in the Recent Document list? 10
VBA code to create a Word 2013 Ribbon tab which lists recent documents 1
Implementing a "Most Recent Files" list 4

Top