How do I make the "MultiSelect" option work in the Application.GetOpenFilename() method? Despite Microsoft’s help page, setting this argument to True doesn’t allow me to select multiple files in the dialog. Answers like this do not help since FileDialog isn’t available on the Mac version of Excel.
What I really want is to prompt the user for a folder instead of a file, but I can’t find out how. So, I’m using subs like this to have the user pick files but as you can see in my screen recording, MultiSelect doesn’t work. I know I can use the file selected to determine the folder
Sub getFolder()
Dim path As Variant
path = Application.GetOpenFilename(FileFilter:="txt", _
MultiSelect:=True)
If path = "False" Then End 'user hit Cancel
End Sub
Ironically, the first time a file is chosen a "Grant Access" dialog appears, which is itself a folder picker — exactly what I want. And yet I can’t figure out how to make a "Grant Access" dialog appear with VBA.
