How do I make the "MultiSelect" possibility work within the Utility.GetOpenFilename() technique? Regardless of Microsoft’s assist web page, setting this argument to True does not enable me to pick out a number of information within the dialog. Solutions like this don’t assist since FileDialog is not obtainable on the Mac model of Excel.
What I actually need is to immediate the consumer for a folder as an alternative of a file, however I am unable to learn how. So, I am utilizing subs like this to have the consumer decide information however as you’ll be able to see in my display recording, MultiSelect does not work. I do know I can use the file chosen to find out the folder
Sub getFolder()
Dim path As Variant
path = Utility.GetOpenFilename(FileFilter:="txt", _
MultiSelect:=True)
If path = "False" Then Finish 'consumer hit Cancel
Finish Sub
Satirically, the primary time a file is chosen a "Grant Entry" dialog seems, which is itself a folder picker — precisely what I would like. And but I am unable to work out how you can make a "Grant Entry" dialog seem with VBA.
