View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default 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