Locate Files of Predefined Extension, in Predefined Location & List in Spreadsheet

Hi All,

I require a bit of code that locates where the excel file is stored - it then searches that directory folder for all file names. Any file names with an extension *.hm for example are listed in column A, while their relevant 'Dates of last Modification' are listed in Column B.

Every time the spreadsheet opens it should ask the user if he/she requires a re-search of this directory and update of any file names accordingly.

NB: if a file name is deleted from the directory, the file name should remain in the spreadsheet.

I don't know if the above can be done - but I welcome your suggestions and example files if you can.

Cheers