recently used file

[lwm]

When I use this code to save a file it works but the file does not show in
the 'recently used file' list in the file menu.

Is there something I can add to have it show in the 'recntly used files' list?

This was a macro record.

ActiveWorkbook.SaveAs Filename:= _
"C:\Documents and Settings\Larry\My Documents\IMA\Jan
19\test04.xls", _
FileFormat:=xlNormal, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False


Thanks

 

[Jim Cone]

Note the addition at the end of the last line...

ActiveWorkbook.SaveAs Filename:= _
"C:\Documents and Settings\Larry\My Documents\IMA\Jan 19\test04.xls", _
FileFormat:=xlNormal, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False, AddToMru:=True

Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)





in message
When I use this code to save a file it works but the file does not show in
the 'recently used file' list in the file menu.

Is there something I can add to have it show in the 'recntly used files' list?

This was a macro record.

ActiveWorkbook.SaveAs Filename:= _
"C:\Documents and Settings\Larry\My Documents\IMA\Jan
19\test04.xls", _
FileFormat:=xlNormal, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False


Thanks