View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz JLGWhiz is offline
external usenet poster
 
Posts: 3,986
Default FileDialog mso folder Picker

You can use the next level icon in this dialog box to move up to the folder
level, although it comes up at the file level.

Sub fndFle()
Application.Dialogs(xlDialogFindFile).Show
End Sub

"CmK" wrote:

Hi

I have tried looking everywhere no one seem to have an answer
is there a File Dialog box
that allows people to pick folders only but still shows the files iinside
the folder


Thanks in Advance