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

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" <(E-Mail Removed)> wrote in message
news:32696E95-485A-4BA1-BF39-(E-Mail Removed)...
> 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

your code picks for folder name, to select file name use

Application.FileDialog(msoFileDialogOpen)


Regards,
Shah Shailesh
http://in.geocities.com/shahshaileshs/
(Excel Add-ins Page)

*** Sent via Developersdex http://www.developersdex.com ***