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

--
Message posted from http://www.ExcelForum.com

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.)



"RNM <" wrote:

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

Thanks,

---
Message posted from http://www.ExcelForum.com/

--

Dave Peterson