xl2002? Then look at:
Application.FileDialog(msoFileDialogFolderPicker)
in the help.

If before, then Jim Rech has a BrowseForFolder routine at:
http://www.BMSLtd.co.uk/MVP/Default.htm
(look for BrowseForFolder)

(You did mean that you wanted the user to select the folder???)

walt wrote:

Thank you, it works fine! Only one last thing to do now :o)

This .LookIn folder should be a variable location... Any ideas? Well, i have
the whole day for trying ;o)

Walt

--

Dave Peterson