Get Folder Name Into Excel List

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

Share