Cannot open files in Most Recently Used List

[Guest]

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

 

[britwiz]

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

 

[Guest]

That's it.
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

 

[Dana DeLouis]

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