Create a workbook from every worksheet in your workbook

This macro will copy every visible worksheet in a new workbook and save the workbook with the name of the sheet in a newly created folder in the same path as the workbook with this macro.

Important: You will notice that when you run the code it will ask you permission to access the folder (Grant File Access Prompt), this is because of Apple’s sandbox requirements. To avid that use a folder in another location, visit this page for more information : Problems with Apple’s sandbox requirements

It will check the file format and will save the new files in the same format. Only if it is a xlsm file and there is no code in the sheet module it will save it as xlsx.

Web design by Will Woodgate