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

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" wrote:

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

windsurferLA wrote:
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