Browse using MS Dialog
 

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

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

Browse using MS Dialog
 

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 ***