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!