Cannot open files in Most Recently Used List
Hi Susan. Don't know if you want to go this route, but here's an option
if you want.
One option is to add a tool bar button to Excel that runs a "SaveAs" macro.
The "SaveAs" method has the option to add the file to the "Most Recently
Used (MRU)" list.
ActiveWorkbook.SaveAs Filename:="MyFileName", AddToMru:=True
Again, just an idea...
HTH
Dana DeLouis
Suzan wrote:
That's it.
Thanks,
Suzan
" wrote:
Suzan wrote:
When I use the menu's "File | Recently used file list" to open say,
Product_List..xls, I get "C:\Documents and Settings\UserName\Local
Settings\Temporary Internet Files\OLK70\Product_List.xls could not be found."
I get this even for locally saved files.
How can I get Excel to open the most recently saved version of Product_List?
Windows XP Start Menu-Documents opens the version I saved, how do I get
Excel to do this?
Thanks,
Suzan
Hi Suzan
That path suggets to me that you've opened a file from an e-mail and
not saved it anywhere else.
Can you navigate to where you think the file is saved via File Open
and open it?
Regards
Steve
|