getting filenames from a user selected folder

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!

Why not use the GetOpenFilename method?

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

In article <[email protected]>,
[email protected] says...
> 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!
>

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
-----------------
"Mitch" wrote:

> 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!