XLSM Macro to list all file names in a specifc folder in the form of List,
After opening file Just make it enabled for macro content, then in new workbook press Alt+F8, it will open macro dialog box, select macro name "FileName' & click on run button #xlsm