View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Most Recently Used File list

Could you add it yourself?

Application.RecentFiles.Add name:="Oscar.xls"

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"altira" wrote in message
...
On 2004-February-Thursday - 05:18:46 was cache-ntc-aa02.proxy.aol.com
( Mozilla/4.0 (compatible; MSIE 6.0; AOL 9.0; Windows NT 5.1; .NET
CLR 1.1.4322) ) with the following IP 198.81.26.7 on your board
Sorry... This is my first time here. Hope I'm doing this right.

It seems the only way to get a file to come up in the "Recently Used
File" list under FILE is to do a secondary Excel "SAVE CHANGES"
process. If I supress the Save Changes process in a macro then the
file fails to be in this list. I'm writting an Accounting program for
others to use, and I want to save them as many steps as possible. Is
there a way around this?

Wish there was a word speller here..

Thanks....