I need to macro that will maintain a workbook that lists all files related to a global warming reduction research project. All files will be saved to and maintained in a user specified Parent Folder or sub-folders of the user specified Parent Folder.
The workbook has the columns listed below:
Path or Location
Date Content Created
Date Last Save
Last Saved by
Comments or Description
The files will be listed in alphabetical order of filename.
The user should be able to click on a “Refresh” button and the macro will search the user specified directory tree or Parent Folder (Cell C1) and all sub-folders for files whose file extensions are “XLSX”, “XLSM”, “XLS”, “DOCX”, “DOCM”, “DOC”, “HTM”, “HTML” AND “TXT.”
The macro will save the filename in the Filename column, the pathname in the Path or Location column, the file extension in the Type column, etc.
Researchers may enter Comments/Descriptions for files listed a possible problem will be to keep the Comments/Descriptions associated with a file.