Thread
:
List of Recent Files
View Single Post
#
5
Posted to microsoft.public.excel.programming
Rick Rothstein \(MVP - VB\)[_1731_]
external usenet poster
Posts: 1
List of Recent Files
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
Reply With Quote
Rick Rothstein \(MVP - VB\)[_1731_]
View Public Profile
Find all posts by Rick Rothstein \(MVP - VB\)[_1731_]