PC Review


Reply
Thread Tools Rate Thread

Browse using MS Dialog

 
 
=?Utf-8?B?Q2FybGVl?=
Guest
Posts: n/a
 
      29th May 2007
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
 
Reply With Quote
 
 
 
 
NickHK
Guest
Posts: n/a
 
      29th May 2007
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



 
Reply With Quote
 
Shailesh Shah
Guest
Posts: n/a
 
      29th May 2007
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 ***
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Browse Dialog Box Brad Microsoft Outlook VBA Programming 1 21st Jul 2009 07:41 PM
browse dialog tray Microsoft Access Form Coding 1 10th Nov 2004 05:53 PM
Browse for dialog not working Brian Microsoft C# .NET 0 2nd Nov 2004 10:28 PM
Browse Network Dialog ? JezB Microsoft Dot NET Framework Forms 1 13th Aug 2004 01:43 PM
Browse Dialog Box in VBA? Raul Microsoft Excel Programming 5 12th May 2004 03:29 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:10 PM.