Open File Dialog box looks like

  • Thread starter Thread starter Steven
  • Start date Start date
S

Steven

I saw where a person was opening a file using excel. The regular open dialog
box that I am used to was not being used or if it was it looked very
different. When they did open it looked more like windows explorer type
window and still had their "My Places" listed on the left.

How is that done?

Thank you,

Steven
 
One way to achieve that will be with the following single VBA command:
SavePath = Application.FileDialog(msoFileDialogFolderPicker).Show
Micky
 
You may also "Google" after: SHBrowseForFolder(bInfo)
Micky
 
SavePath = Application.FileDialog(msoFileDialogFolderPicker).Show
Click to expand...

That is not usually the best way to go. If the dialog is cancelled,
nothing happens, but if the OK button is clicked, the result is -1 and
the current drive and directory are modified. This modification could
cause other pieces of code to fail. A better way is to use the API
function to browse for the folder.

See http://www.cpearson.com/Excel/BrowseFolder.aspx for code details
and examples.

Cordially,
Chip Pearson
Microsoft MVP 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
[email on web site]
 
Back
Top