About Us

Nigel[_2_]

Oops! Apologies I missed that point.

--

Regards,
Nigel

"Rick Rothstein (MVP - VB)" wrote in
message ...
True, but the OP asked about Excel 2003.

Rick

"Nigel" wrote in message
...
It's 50 in Excel 2007

--

Regards,
Nigel

"Rick Rothstein (MVP - VB)" wrote
in message ...
According to the help files, the Maximum property can only be a value
from 0 to 9.

Rick

"Nigel" wrote in message
...
Application.RecentFiles.Maximum = 50

--

Regards,
Nigel

"Steph" wrote in message
...
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.

--
Steph

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
exporting/saving recent files list	vabki	Excel Discussion (Misc queries)	3	December 17th 09 07:11 PM
Attachments in recent files list	Marcelo L. Arruda	Excel Discussion (Misc queries)	0	April 23rd 09 01:17 AM
show most recent files first when opening excel files	Anne`	Excel Discussion (Misc queries)	5	January 23rd 08 01:54 AM
Files not in "My Recent Documents" list	JasonJ1052	Excel Discussion (Misc queries)	2	October 14th 07 02:25 PM
How make 7 recent Excel files appear on Excel2003 list?	AmyLowCPA	Excel Discussion (Misc queries)	2	December 23rd 06 05:11 PM

Menu

About Us