how to use msoFileDialogFolderPicker ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm not sure if I'm using this right. The following code lets me choose a
folder, but it does not show what files are in it. This means the user has
to check that the folder is correct (using Explorer or My Computer) before
committing the dialog selection.


Private Sub cmdChangeFolder_Click()

' N.B. Need to write a custom dialog that shows files in folder
' (so user know the bloody thing isn't empty!)

With Application.FileDialog(msoFileDialogFolderPicker)
.AllowMultiSelect = False
.Show
pubInputFolder = .SelectedItems(1)
txtFolder = pubInputFolder
End With

End Sub


Is there something else I should be doing?

Thanks!
 
Hi Alex,

I have tried out this code successfully, however, the number of files you
can select is quite limited (less than 25 in my case). I would like to extend
this to up to 200 files. Can you help me out?

Thanks
Gert
 
Back
Top