View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tenlbham tenlbham is offline
external usenet poster
 
Posts: 10
Default Is there a Folder Picker method that shows files too?

I want to browse for a folder where certain files are located. The code is
just the basic:

With Application.FileDialog(msoFileDialogFolderPicker)
.AllowMultiSelect = True
If .Show = False Then Exit Sub
MyFolder = .SelectedItems(1)
End With

.... but is there a way to be able to see the files in the browser as well as
the folders?

Thanks!