Find Folders
 

I need to find a way to ask the user to select or find a folder and capture
the path. Can anyone help with this?
--
sewcsw

Find Folders
 

Jim Rech has a BrowseForFolder routine at:
http://www.oaltd.co.uk/MVP/Default.htm
(look for BrowseForFolder)

John Walkenbach has one at:
http://j-walk.com/ss/excel/tips/tip29.htm

If you and all your users are running xl2002+, take a look at VBA's help for:
application.filedialog(msoFileDialogFolderPicker)

SteveW wrote:

I need to find a way to ask the user to select or find a folder and capture
the path. Can anyone help with this?
--
sewcsw

--

Dave Peterson