View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
RB Smissaert RB Smissaert is offline
external usenet poster
 
Posts: 2,452
Default FileDialog grey's out the View box

I am not sure it can be done with FileDialog object, but if you want I can
post API code that gives you much more control and that can do it.

RBS

"Budget Programmer" wrote in
message ...
Hello,
I want to select one particular folder, but I need the view box to appear
so
that I can sort the folders by modified date, name, etc. The "View" box
is
greyed out.
Thanks for you help.

Private Sub GetFolderName()

Dim strSelectedFullFolder As String
Dim strSelectedFolder As String
Dim fd As FileDialog
Set fd = Application.FileDialog(msoFileDialogFolderPicker)
With fd
.AllowMultiSelect = False
.InitialView = msoFileDialogViewDetails
.Show
strSelectedFullFolder = .SelectedItems(1)
strSelectedFolder = Mid(strSelectedFullFolder, 68,
Len(strSelectedFullFolder))
End With

End Sub

--
Programmer on Budget