John Walkenbach shows you how to display the standard folders selection
dialog - sample code at:
http://j-walk.com/ss/excel/tips/tip29.htm
Selecting a directory
If you want to start from a specific location as the pre-selection, you can
use a more complex version provided by Jim Rech on Stephen Bullen's site on
the MVP page.
http://www.BMSLtd.co.uk/MVP/default.htm
Regards,
Tom Ogilvy
"Helge V. Larsen" wrote in message
...
I have used the "GetSaveAsFilename method" to let the user give a file
name.
But now I need a "GetFolder method" that will let the user give a folder
name. The "GetFolder method" does not exist in VBA. Has anyone programmed
something that can do the trick ? - or can you give me a hint on how to do
it ?