Browse using MS Dialog

[Guest]

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

 

[NickHK]

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

 

[Shailesh Shah]

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)