Microsoft Excel

Ron de Bruin
Excel Automation

Microsoft MVP Program

Merge Excel workbooks on a Mac

In the example workbook that you can download below you find three macro examples and some tips how to change the code to fit your needs in Excel 2011 and up.
Note: I use my Custom Dir function for the Mac in the example workbook to get the file names I want.

Note: If you use O365 Excel 2016 or higher with the latest updates you can also use VBA Dir now to loop through the files in a folder, check out the page with the custom Dir function above for more information and a code example to loop throug the files in a folder.

Download Example workbook
Function version 4.0: 27-Sept-2015

Double-click the dmg file if it does not mount automatically. Drag the file to the folder you want on your Mac. Tip: Use one folder for all your example files (easy to backup your files this way)