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

Problems created by Recent updates to Outlook 365 0
New computer, how do i move outlook 365 ENTIRELY? 0
Need some PWA help 0
Loosing transparency effect of Master Page graphic when Saving Publisher files as .pdf 0
Automation of scanned file storage based on content 0
Record Name of Workbook on Close 4
2 Most recent files 3
Macro to delete Recent Files list (except those "pinned") - Excel 3

Top