Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Open Dialog Box to return Selected File Path and Not Open it. | Excel Programming | |||
File open dialog box | Excel Discussion (Misc queries) | |||
File Browse Function (Open dialog box for choosing file) | Excel Programming | |||
File Open Dialog | Excel Programming | |||
open file dialog-select file-import worksheet | Excel Programming |