View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default Browse using MS Dialog

Carlee,
Because you are browsing for a folder, not a file, hence the enum is called
"msoFileDialogFolderPicker".
See the reply to your later post.

NickHK

"Carlee" wrote in message
...
I use the following code to call the Browse Dialog to select a file.

Problem
is, the dialog box doesn't show any Excel files. Can you help?

With Application.FileDialog(msoFileDialogFolderPicker)
.Show
MsgBox .SelectedItems(1)
End With

--
Carlee