A
Adolf Gerold
Hallo VBA-friends
I've wrote a Makro, which deletes the filelist
of the file-menu:
Sub ClearFileList()
Application.DisplayRecentFiles = False
Application.DisplayRecentFiles = True
RecentFiles.Maximum = 9
End Sub
It works correctly, but only if a worddocument is
opened. Otherwise i got an error message.
Can anybody tell my how to solve this problem.
I think, I ask after an open document and if there
is none, I let the macro open one, clear the filelist
and let the makro close the document.
But what's the code?
Thank you for your effort
with kind regards, Adi
I've wrote a Makro, which deletes the filelist
of the file-menu:
Sub ClearFileList()
Application.DisplayRecentFiles = False
Application.DisplayRecentFiles = True
RecentFiles.Maximum = 9
End Sub
It works correctly, but only if a worddocument is
opened. Otherwise i got an error message.
Can anybody tell my how to solve this problem.
I think, I ask after an open document and if there
is none, I let the macro open one, clear the filelist
and let the makro close the document.
But what's the code?
Thank you for your effort
with kind regards, Adi