File Open Dialog
 

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

File Open Dialog
 

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

File Open Dialog
 

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

File Open Dialog
 

fn = Application.GetOpenFilename()

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



"John" wrote in message
...
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

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