Sample Header Ad - 728x90

Application.GetOpenFilename() MultiSelect option doesn't work in Mac Excel VBA

0 votes
0 answers
40 views
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. enter image description here 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.
Asked by Tony M (1006 rep)
May 11, 2025, 07:19 AM
Last activity: May 11, 2025, 07:38 AM