In Windows we can use for example GetOpenFilename to select files and do what we want with the path results, you can use filefilter to only display the files you want and use MultiSelect to select more than one file. Also it is possible with ChDrive and ChDir to set the folder that is selected when GetOpenFilename opens.

But on a Mac the filefilter is not working and it is not possible to select more than one file. Also ChDir is not working like in Windows to set the folder that will open with GetOpenFilename. But we can use a combination of VBA and Applescript, see the examples below that only let you select xls, xlsx and xlsm files, and you can also set the start folder and also say if you want to select one or one or more files..

Below you will find two example macro's and a function that both macro's use. Both macro's open the Desktop folder in the browse window, you can open the first macro without changing it, because it use MacScript to get the Desktop folder path, in the second macro you must enter the path yourself. In both macro's you can only select xls, xlsx or xlsm files, see the function call in the macro's with the three arguments how to change this for selecting only one file or other file formats. For testing it will show a msgbox with the path of each file you have selected.

In the function call in the macro you see this code part that say which file format you can select, xls, xlsx and xlsm. You see that I add 3 file formats in the examples, but you can change that if you also want to add for example xlsb files.

If you only want one format you can use this to be able to only select xlsx files for example.

"{""org.openxmlformats.spreadsheetml.sheet""}"

This is a list of a few formats that you can use :