Populate all XLSM file names from folder to listbox showing A1 inf. of each file

[fountain95]

I have a folder named FORMS where I save all my xlsm files.


I need to create a wookbook that will list each one of the xlsm files, plus extract the inf. of A1 cell of each file and listed it next to the name of each file, plus a link to open the file.

Example: I have inside the FORMS folder 2 files named 123.xlsm with value form1 on A1 cell and a file named 132.xlsm with a value form2 on A1 cell.

I want to have it listed as follow...

FILE = 123 NAME= form1 LINK TO THIS FILE
FILE = 132 NAME= form2 LINK TO THIS FILE

I am just new to this, can someone send me a sample file or something that I can see how it works?

Please see attached file

Thank you