how to pull folders name from a path in excel

[tushjain00]

Hello,
Please someone can give me a vba code which can pull just the folder name from a path?

I have some 1500 folders in a shared drive which is on a server mapped to my computer, how can I get all the 1500 folders name in an excel sheet?

Any help is appreciated please.
THanks

[ImranBhatti]

Give the attached a shot.

Unable to post a shell /stdout snippet here

[tushjain00]

On running the macro, a blank dialog box came which i pressed ok, but nothing it did, no names got listed on excel sheet.

[ranman256]

usage:
ScanSubfolders "c:\myFolder"

Please Login or Register  to view this content.

[ImranBhatti]

Ok

I have made it dynamic a little bit. please run ListAllSubFolders subroutine and select a folder

[tushjain00]

it is giving an error debug at this below line:

Please Login or Register  to view this content.

[tushjain00]

When i run this, it says in a dialog box macro name and create option. This doesnt run the normal way a macro runs. Can you help please?

Do I need to edit some of the code to input the path of the folder?

[ImranBhatti]

When i run this, it says in a dialog box macro name and create option. This doesnt run the normal way a macro runs. Can you help please?

It happens when you run a function instead of subroutine

I don't know you have a button for for the macro or not but if you want to run it from the VBE window then your cursor should be anywhere inside the ListAllSubFolders subroutine then press F5 and select a folder in the dialoge box that appears