getting filenames from a user selected folder

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

Guest

I need to have the user select a folder using msoFileDialogFolderPicker then
get the count and file names of all files in the folder. Please help!
 
Help with what? If you know you have to use msoFileDialogFolderPicker
you have to know the context in which it makes sense. So, where are
you stuck?

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
I found a way to accomplish this...

With Application.FileDialog(msoFileDialogFolderPicker)
.AllowMultiSelect = False
.Show
THEpath = .SelectedItems(1)
End With
With Application.FileSearch
.LookIn = THEpath
.FileType = msoFileTypeExcelWorkbooks
.Execute
ALLcount = .FoundFiles.Count
For i = 0 To ALLcount - 1
ALLpaths(i) = .FoundFiles(i + 1)
Next i
End With
 
Back
Top