View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Nigel[_2_] Nigel[_2_] is offline
external usenet poster
 
Posts: 735
Default 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