LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 947
Default 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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel workspace loses formatting Snarf Excel Discussion (Misc queries) 3 March 16th 06 03:47 PM
Can Only open files using file ~ open tek4u Excel Discussion (Misc queries) 4 July 11th 05 05:31 PM
Can not open excel files without open application Taarfa Excel Discussion (Misc queries) 3 July 9th 05 11:56 PM
Excel files will not open from a shortcut in XP. How do I fix thi John Gordon Wadhurst Excel Discussion (Misc queries) 3 May 16th 05 01:03 PM
File Open - don't want to see .htm files Dan Reynolds Excel Discussion (Misc queries) 0 February 5th 05 01:13 AM


All times are GMT +1. The time now is 03:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"