Display recently used files

[casey wolfe]

Hi, please help, I noticed that in Excel 2000, it will
display recently used files in the file menu. There are
files I haven't touched in 3 months in there. Yet, the
one I used yesterday isn't there. It should be, because it
is the most recently accessed file there, right? Is there
a trick that I am missing????? I know about the little
checkbox under "tools-options-general tab" that says
"recent files" and "number of files to display". Is there
something else I am missing?????? Please help any advice
will be greatly appreciated!!!!!

Thanks a million in advance, I always reply to anyone who
gives me advice.
Casey K. Wolfe

[Debra Dalgleish]

Files that you open by choosing File>Open, or clicking the Open button,
will appear on the recently used list. Files that you open from
desktop shortcuts, or through Windows Explorer, won't appear in the list.

casey wolfe wrote:

--

Debra Dalgleish

Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

[Peo Sjoblom]

Casey,

maybe you open these recent files by double-clicking them or through explorer?
The recent list will only be files that are opened using file>open in excel..

--

Regards,

Peo Sjoblom

"casey wolfe" <wolfeNOga...@hotmail.com> wrote in message news:8b9301c2080b$3c11d7e0$36ef2ecf@tkmsftngxa12...

[Dave Peterson]

I'm not sure if you two noticed this, but with xl2002, double clicking while in
Windows Explorer does add it the MRU list.

(I was corrected earlier this week on this one, too!)

--

Dave Peterson
ec3...@msn.com

[Dave Peterson]

I'm using xl2002 right now, but when you do a File|Open in xl2k, there's a
button on the left side that says History. (In xl2002, the explorer opened
files show up in both the MRU list and under that History button.)

Maybe you could use that for the files that you opened via double clicking in
explorer.

--

Dave Peterson
ec3...@msn.com

[Debra Dalgleish]

I did notice, but tested in Excel 2000, as that was what the OP was
using. (Probably Peo didn't notice though. <g>)

[Dave Peterson]

I've only been using xl2002 for a few (more than I'd want to guess) and never
noticed it.

It's hard to teach an old dog new tricks.

Woof, woof.

--

Dave Peterson
ec3...@msn.com

[Debra Dalgleish]

I didn't say *when* I noticed. (It was approximately 2:55 p.m. today, as
I was testing for this question. <g>)

And please don't bark -- I finally got rid of that darn Windows Explorer
Search Window dog, and don't want to be reminded.

[Dana DeLouis]

If you are opening Excel files thru Windows Explorer, you may want to run a
macro similar to this to add it to the MRU list. (Most Recently Used).

Sub MRU_AddToList()
'// = = = = = = = = = = = = =
' Adds ActiveWorkbook to the MRU list
' By: Dana DeLouis
'// = = = = = = = = = = = = =

With Application
' Make sure Option is turned on.
If Not .DisplayRecentFiles Then
.DisplayRecentFiles = True
.RecentFiles.Maximum = 9
End If

' Make sure Document is Saved
If ActiveWorkbook.Path = vbNullString Then
MsgBox "Please Save Document first !", vbCritical
Exit Sub
End If

' Remove Invalid MRU's
MRU_CleanUp

' Add to MRU list
.RecentFiles.Add Name:=ActiveWorkbook.FullName
End With
End Sub

Sub MRU_CleanUp()
'= = = = = = = = = = = = ="
'// Deletes MRU that are no longer valid
'// By: Dana DeLouis
'= = = = = = = = = = = = ="
Dim j As Integer
With Application.RecentFiles
For j = .Count To 1 Step -1
If Len(Dir(.Item(j).Path)) = 0 Then
Debug.Print
Debug.Print "= = = = = = = = = = = = ="
Debug.Print "MRU file no longer valid..."
Debug.Print .Item(j).Name & " : " & .Item(j).Path
Debug.Print "= = = = = = = = = = = = ="
Debug.Print
.Item(j).Delete
End If
Next j
End With
End Sub

--
Dana DeLouis
Windows XP & Office XP
= = = = = = = = = = = = = = = = =

"casey wolfe" <wolfeNOga...@hotmail.com> wrote in message
news:8b9301c2080b$3c11d7e0$36ef2ecf@tkmsftngxa12...