Problem in updating file details automatically in excel from folder

[klpw]

Hi all,

I've come up with the code for listing folder name, file name, revision with its last modified date details for a folder. At the moment, I would like to make the sheet being updated automatically whenever there is a file being deleted, new file being added or file being modified. Can anyone help me with this? Please see attached file for the code.

Thanks in advance.

 

[Marc L]

Hi !

Just easy logic !
If files are created or modified by a VBA code, just amend the code
to update the worksheet … If not, just run again your initial procedure !
​