Exporting to Excel does not show the Macros included in the XLSM file to execute it.
The export wizard does not show any MACRO in the last step so it is not possible to use them
Macros are not enabled in the Excel file
In an Excel 2007 or later workbook, in order to include a macro, you must save your Excel file as an .xlsm (Excel Macro-Enabled Workbook) file.
You must also enable macros in the Excel file. To do this, go to Microsoft Office button | Excel Options | Trust Center | Trust Center Settings | Macro Settings and select Enable all macros. Also, select Trust access to the VBA project object model.