J
JJ
Dear All. I have posted before but couldn't really get an answer. I am
going to try rephrazing the question as I think I explained
incorrectly. I am not trying to change the file open dialog box, I
merely want to change the way the folder is viewed. For example if I
create a macro as listed below, when I click on File, Open my dialog
box will be displayed with details of the files. What I am trying to do
is set the type of details being displayed. For example, by default the
Name, Date and Size will be displayed. I would like to include the
Comments field. Is there any way of doing that?
Sub FileOpen()
Dim fd As FileDialog
Set fd = Application.FileDialog(msoFileDialogFilePicker)
With fd
.InitialView = msoFileDialogViewDetails
If .Show = -1 Then
End If
End With
End Sub
going to try rephrazing the question as I think I explained
incorrectly. I am not trying to change the file open dialog box, I
merely want to change the way the folder is viewed. For example if I
create a macro as listed below, when I click on File, Open my dialog
box will be displayed with details of the files. What I am trying to do
is set the type of details being displayed. For example, by default the
Name, Date and Size will be displayed. I would like to include the
Comments field. Is there any way of doing that?
Sub FileOpen()
Dim fd As FileDialog
Set fd = Application.FileDialog(msoFileDialogFilePicker)
With fd
.InitialView = msoFileDialogViewDetails
If .Show = -1 Then
End If
End With
End Sub