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

[fountain95]

I have a folder name 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 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 in A1 cell of form1 and a file named 132.xlsm with value in A1 cell of form2.

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?

Thank you

[abousetta]

Hello,

This thread seems to be a duplicate to your previous thread. If so, please bump your last thread rather than starting a new thread.

abousetta

[fountain95]

OK I have been trying this, but I am new. I want to delete the one I did before and I keep this one. But don't know how to do it.

When I post a thread wronly and I need to delete it, how I do it?

[abousetta]

Hello,

You can contact RoyUK. He will be able to lock the previous thread.

Good luck and welcome again to the Forum.

abousetta