Deal with foldernames

Hi there,

I am trying to create a macro that picks the name of some folders (around 300) and writes them in cells in the spreadsheet.

I am thinking in some function similar to GetOpenFilename that allows to pick the name of one file and write it into a variable, but that allows you to work with 'folder names' and not 'file names'

What I would like to do is a macro that automaticaly picks up the first name stores it on a cell and goes for the next. And so on...

Can anybody help on this?

I'd love not to have to go on to that manually...

Thanks in advance!

Good afternoon

You want a macro that lists all directorys in a given directory?
Is this OK?

Please Login or Register  to view this content.

Copy it into an empty module and run the macro "Test".

HTH

DominicB

Ok? Just Ok? No! It is almost exactly what I was looking for!

Thanks and re-thanks for the fast answer!

This will keep me away from an awfull copy to spreadsheet boring and long work.