File Open Dialog
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
---------------
Jacob Skaria
"John" wrote:
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
"Jacob Skaria" wrote:
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
---------------
Jacob Skaria
"John" wrote:
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
|