Get Folder Path

[RNM]

Is there a way to get the user to select a folder, via a dialog box.
know how to get the file open dialog, but I just want the folder.

Thanks

 

[Dave Peterson]

In xl2002+, you can use the built in:
application.filedialog
(there's a nice example in help).

In earlier versions, you could use the code at John Walkenbach's site:
http://j-walk.com/ss/excel/tips/tip29.htm

(actually, you could use that in xl2002+, too.)