Solved Getting a directory path

[PaquettePaul]

I have a form that sends PDFs and excel spreadsheets to a given directory path location. Currently, I have the path stored in a configuration field in the database. However, I would like to provide the user with the option of browsing through the directory until they find where they want the file to be stored.

i have tried using the Application.FileDialog(msoFileDialogFilePicker).Selected Items(1) approach to obtain the directory path but a) you need to select a file to get the path and, when I do, b) the contents of the SelectedItems is the full path along with the file name. I only want the directory path.

wondering what I am doing wrong or is there another way. I could always just use an empty field that they type in but that is pretty basic.

thanks

 

[PaquettePaul]

That did the trick. Thanks a bunch