Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Open Dialog Box to return Selected File Path and Not Open it. DMS Excel Programming 4 January 26th 10 12:46 PM
File open dialog box [email protected] Excel Discussion (Misc queries) 1 March 21st 07 03:01 AM
File Browse Function (Open dialog box for choosing file) b-123 Excel Programming 1 August 25th 05 10:06 PM
File Open Dialog scantor145[_3_] Excel Programming 1 September 29th 04 12:04 AM
open file dialog-select file-import worksheet Divinedar Excel Programming 1 January 16th 04 07:13 PM


All times are GMT +1. The time now is 02:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"