View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default recently used file


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)





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