Loop through Files in Folder on Mac
VBA Dir is fixed now in the latest updates if you use 2019 or O365, you can use Dir now to loop through files in a folder and use wildcards to filter to only loop through the files you want. See the basic example below that create a new file with a list of all the files in the folder that you select when you run the code.
Example with MacScript for Excel 2011 and higher
Download this example workbook with and example that is working in Excel 2011 and higher.