Recently Used File List Doesn't show saves

[windsurferLA]

I have moved several VB modules from a converted XL95 workbook into a
new XL97 workbook. I have also pasted in John Walkenbach's menu maker
utility into the new XL97 workbook. Now, after a file is saved, the
saved file name no longer shows up in the "recently used file list"
under "files" in the EXCEL menu. In the Tools \ Options \ General menu,
I have indicated that the last 9 entries are to be saved.

How might I restore this feature?

WindsurferLA

 

[Bill Linker]

Programmatic saves do not set the Most Recently Used (MRU) list unless you
set the option in the save function. Here is the code from one of my modules
for a save as. Note that the following was written for Excel 2002, so the
option may be named differently or unavailable in Excel 97.

Workbooks(wrkBkName).SaveAs FileName:=saveFileName, FileFormat:=xlNormal, _
AddToMru:=True

 

[windsurferLA]

I have moved several VB modules from a converted XL95 workbook into a
new XL97 workbook. I have also pasted in John Walkenbach's menu maker
utility into the new XL97 workbook. Now, after a file is saved, the
saved file name no longer shows up in the "recently used file list"
under "files" in the EXCEL menu. In the Tools \ Options \ General menu,
I have indicated that the last 9 entries are to be saved.

How might I restore this feature?

WindsurferLA

A response to this post indicates the need for AddToMRU:=True
See next post for problem when including AddToMRU:=True