Hi all,

I have code for showing file details in a folder, for instance, the folder name, the file name, revision with its last date modified details. Yet, I would like to update the list automatically when the user removes a file from the folder, adds a file in the folder as well as modifies a file in the folder. May I know how can I achieve this? Can anyone help? Please see attached my code.



Thanks in advance.

Attached Files

code.xlsm (21.8 KB, 11 views)

Excel doesn't have event-driven capabilities for folder monitoring. What you could do, however, is change the name of your PrintFolders macro to Auto_Open, so it runs automatically every time the workbook is opened.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]