I'm using the following code to grab the folder name where my files sit. The troubling this is I can't see the files when I'm in the browser. Is there a way to grab the folder name AND see it's contents???
Set dlgOpen = Application.FileDialog(msoFileDialogFolderPicker)
dlgOpen.Show
Set dlgOpen = Application.FileDialog(msoFileDialogFolderPicker)
dlgOpen.Show