| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| exporting/saving recent files list | Excel Discussion (Misc queries) | |||
| Attachments in recent files list | Excel Discussion (Misc queries) | |||
| show most recent files first when opening excel files | Excel Discussion (Misc queries) | |||
| Files not in "My Recent Documents" list | Excel Discussion (Misc queries) | |||
| How make 7 recent Excel files appear on Excel2003 list? | Excel Discussion (Misc queries) | |||
Linear Mode
