View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Budget Programmer Budget Programmer is offline
external usenet poster
 
Posts: 46
Default FileDialog grey's out the View box

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