Is is possible using VBA in Excel to clear ALL items in the recently used
file list?
I'm talking about the recently used files when you click "Start" then
"Documents".
If this is possible, could someone please post the code to do this?

Thanks.

HiQuartz,

If you want to hide the Excel recent file list display, try:

Sub Tester()
Application.DisplayRecentFiles = False
End Sub

If you want to clear and re-initialise the list, try:

Sub Tester02()
With Application
.DisplayRecentFiles = False
.DisplayRecentFiles = True
.RecentFiles.Maximum = 3 '<<==== CHANGE TO SUIT
End With
End Sub

Note that neither of the subs erases the windows recent file list, only
Excel's ability to report the list.

---
Regards,
Norman



"quartz" wrote in message
...
Is is possible using VBA in Excel to clear ALL items in the recently used
file list?
I'm talking about the recently used files when you click "Start" then
"Documents".
If this is possible, could someone please post the code to do this?

Thanks.

Hi quartz,
You can use:
Kill CreateObject("WScript.Shell").SpecialFolders("Rece nt") & "\*.*"

Regards,
MP

"quartz" a écrit dans le message de
...
Is is possible using VBA in Excel to clear ALL items in the recently used
file list?
I'm talking about the recently used files when you click "Start" then
"Documents".
If this is possible, could someone please post the code to do this?

Thanks.

Thanks so much!!!

"Michel Pierron" wrote:

Hi quartz,
You can use:
Kill CreateObject("WScript.Shell").SpecialFolders("Rece nt") & "\*.*"

Regards,
MP

"quartz" a écrit dans le message de
...
Is is possible using VBA in Excel to clear ALL items in the recently used
file list?
I'm talking about the recently used files when you click "Start" then
"Documents".
If this is possible, could someone please post the code to do this?

Thanks.