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
|