How do I get the names of each Excel workbook located in a folder with a macro?
Posted on 2016-11-16
I have a folder in path G:\Share. In the folder a have a lot of excel workbooks. Is there code that can be run from Excel to capture the name of each workbook without the extension .xlsm? Below is a sample of what is in my folder and what I want.
Folder Contents What I Want on Excel
ABC Construction.xlsm ABC Construction
River Works.xlsm River Works