Hi,
Below is the VB code I am using to let users select the folder they want to save a file.My problem is once user selects a folder, none of the files in that folder is displayed. I understand it is because I am using FileDialogFolde rPicker.
My question is, when user selects a folder, is there a way to show all existing files under that folder, and also let them save the new file in the same folder.
I want users to be able to see all files under the folder they selected so that they can be sure it is the same folder where they saved the file last time. Please help. Thanks.
Dim fd As FileDialog
Set fd = Application.Fil eDialog(msoFile DialogFolderPic ker)
Dim vrtSelectedItem As Variant
With fd
.TITLE = "Select a folder"
.AllowMultiSele ct = False
.Show
If .SelectedItems. Count > 0 Then
InputFile = .SelectedItems( 1)
End If
End With
Set fd = Nothing
Below is the VB code I am using to let users select the folder they want to save a file.My problem is once user selects a folder, none of the files in that folder is displayed. I understand it is because I am using FileDialogFolde rPicker.
My question is, when user selects a folder, is there a way to show all existing files under that folder, and also let them save the new file in the same folder.
I want users to be able to see all files under the folder they selected so that they can be sure it is the same folder where they saved the file last time. Please help. Thanks.
Dim fd As FileDialog
Set fd = Application.Fil eDialog(msoFile DialogFolderPic ker)
Dim vrtSelectedItem As Variant
With fd
.TITLE = "Select a folder"
.AllowMultiSele ct = False
.Show
If .SelectedItems. Count > 0 Then
InputFile = .SelectedItems( 1)
End If
End With
Set fd = Nothing
Comment