Recently Used File List

[Farah]

Any possibility to increase "Recently Used File List" more than 9 ?

Warm Regards,
Farah

 

[Tazguy37]

(Very quiet voice): As far as I know, you can't. Even if you change the number via VBA code, the max (at least in 2000) is still 9. I'll check later on when I get to a pc running 2003.

 

[Farah]

i am using 2003, so yes... if you can check for this version.

Warm Regards,
Farah

P.S. How can i put my picture on the board, like erik has done ? is this question O.k to be posted here ?

 

[Tazguy37]

i am using 2003, so yes... if you can check for this version.

Warm Regards,
Farah

I'll do that and get back to you.

P.S. How can i put my picture on the board, like erik has done ? is this question O.k to be posted here ?

Go to your profile (top of the page, under the FAQ hyperlink) and scroll all the way down to the avatar control panel.

 

[DominicB]

Hi guys

Sorry to interrupt - just to confirm that the max number of files in the Excel 2003 history is ... 9 (even if accessed thru VBA).

HTH

DominicB

 

[Tazguy37]

Did you look up the Maximum Property of the RecentFiles Collection Object as well? 'Cause if you did, and it's still 9, that sucks. :x

 

[DominicB]

Sorry Taz.

Still 9 whichever way you look at it.

As you probably know Excel 12's on the horizon and, you just never know, someone at Microsoft might have just had a bright idea ... (maybe).

HTH

DominicB

 

[Tazguy37]

Really. I mean, how hard would it be to make that ... 100, if the user wanted to? It's just a string array -- big deal.