Open File Dialog box looks like

[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

 

[Chip Pearson]

SavePath = Application.FileDialog(msoFileDialogFolderPicker).Show

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]