Get Folder Name Into Excel List Using Excel Macro
Tool to download : get folder name to excel.xlsm
Purpose : extract folder name inside directory “C:\Program Files (x86)”
1. Download and extract “get folder name to excel.xlsm”
2. Double click “get folder name to excel.xlsm”
3. Click “Enable Content”
4. Edit the Macros
5. Modify The Directory inside the macros code
6. Close the Microsoft Visual Basic for aplication window
7. Run the Macros
8. All Done
See the video :
download tool : here
Thanks for reference : Bob Phillips
http://www.excelforum.com/excel-programming-vba-macros/511330-extract-folder-names-only.html
