fboehlandt
Active Member
- Joined
- Sep 9, 2008
- Messages
- 334
Hi everyone
I am using the Application.FileDialog method to prompt a user to select a folder:
Is there an option to prevent the user from creating a "New Folder" and then selecting that one? Something on the lines of folderDialog.AllowExisting = False?
Thanks in advance
I am using the Application.FileDialog method to prompt a user to select a folder:
Code:
Function GetFolderPath(MyTitle As String) As String
'Browse for target folder
Dim folderDialog As FileDialog
Set folderDialog = Application.FileDialog(4)
With folderDialog
.Title = MyTitle
End With
folderDialog.AllowMultiSelect = False
folderDialog.Show
GetFolderPath = folderDialog.SelectedItems(1)
End Function
Is there an option to prevent the user from creating a "New Folder" and then selecting that one? Something on the lines of folderDialog.AllowExisting = False?
Thanks in advance