View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mikerosoft Mikerosoft is offline
external usenet poster
 
Posts: 3
Default Most recent file list

Yesterday i worked with 3 different people, who couldnt find a file,
the most recently used file list should have been 100 files long.

I am sure this would be very helpful for many users.

I thought of every time a file is opened writing the file name location
and date to sheet 1 of the personal xls file, then adding a new menu
item that would show those files as a hyperlink list.

BUT, how can i have excel record when a file is opened? can i do from
an event in the personal book?

Help greatly appreciated!

~M