Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
'Recently used file' list. | New Users to Excel | |||
recently used file list | Excel Discussion (Misc queries) | |||
The 'Recently used file list' does not show up under the 'File' menu. | Excel Worksheet Functions | |||
Recently Used File List | New Users to Excel | |||
Most Recently Used File list | Excel Programming |