File Open Dialog

[John]

Is there a setting in Excel (or an alternate solution) that when one clicks
on File/Open, a Windows Explorer dialog box appears in a split window.
Folders on the left and folder contents on the right.

Thanks,
John

 

[Jacob Skaria]

John

The File Dialog should do..

Dim strFile as Variant
With Application.FileDialog(msoFileDialogOpen)
.AllowMultiSelect = False
.Filters.Add "Excel Files", "*.xls", 1
.InitialFileName = "C:\"
.Show
strFile = .SelectedItems(1)
End With

If this post helps click Yes

 

[John]

Jacob,

Thanks for the reply. I am familiar with "FileDialogOpen" but I am after
the Windows Explorer look/feel where there is a split window. Folders in the
left window and folder contents in the right window.

Regards,
John

 

[Patrick Molloy]

fn = Application.GetOpenFilename()

read help on this as you can add filters for the file type

 

[Jacob Skaria]

There is no other available ones within Excel Applicaiton which is designed
the way you have mentioned..

(Hope you have tried Folder browse API also)

If this post helps click Yes