John has some code for allowing users to select a directory.
John Walkenbach : Selecting a Directory
http://j-walk.com/ss/excel/tips/tip29.htm
HTH
Paul
--------------------------------------------------------------------------------------------------------------
Be advised to back up your WorkBook before attempting to make changes.
--------------------------------------------------------------------------------------------------------------
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 ?