List of Recent Files
 

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

List of Recent Files
 

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

List of Recent Files
 

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

List of Recent Files
 

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

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

List of Recent Files
 

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