Extract Folder and SubFolder Names in Excel using VBA

GitHub:
github.com/hav...
40 Under 40 Analytics
Indian Achievers Award for Young Entrepreneur
Consulted Government of India, Fortune 500, Unicorns, Big 3 and Big 4
Faculty at IIM ABCLK + IITs
Author of 20 books
Website:
www.havishmcon...
Courses:
www.havishmcon...
Medium:
/ havish-madhvapaty
GitHub:
github.com/hav...

[@chetnamalik5585]

This code is really useful, thank you for making such videos

[@HavishMadhvapaty]

Thanks :)

[@LeeTuanAnh100]

Very nice, but in Subfolder i think you should add Extension file colum to know what type of file.

[@HavishMadhvapaty]

Agreed :)

[@LeeTuanAnh100]

it's just works to subfoler name, could you adds more code to extract files name in folder and subfolder ?

[@HavishMadhvapaty]

github.com/havishmad/excel_file_names_from_folder

[@MrEmoroz]

You can do that in power query. It works much better and refreshes dynamically. This is specifically useful when there is not content in the folders.