Forum Discussion

mauricev2's avatar
mauricev2
Copper Contributor
Sep 02, 2022
Solved

VBA: can’t get an application file dialog on the Mac

On Excel Windows, this line of code

 

With Application.FileDialog(msoFileDialogFolderPicker)

works. It brings up a file dialog showing folders.

 

But on the two Mac Pros running Monterey,, the command is ignored. Why might this be?

  • Here is the answer: https://anywarellc.com/2021/03/31/excel-vba-file-dialog-on-a-mac/

Resources