recently used file
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 |
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 |
All times are GMT +1. The time now is 10:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com