See John Walkenbach's site for sample code:

http://j-walk.com/ss/excel/tips/tip29.htm
Selecting a Directory
--
Regards,
Tom Ogilvy

"Philipp Schramek" wrote in message
...
Dear all
With GetOpenFilename() I can start the "open"-Window to find a file and
return a file name with its path.
I only want to return a path without a file name. Is there an equal way
to do it. I somehow remember that I saw a command but I cannot remember
it. Something like GetOpenPathname.
Thanks Philipp