using a template with marco to export data

I am exporting data from the application to a template excel file if i use EXCELFILE.xlsx to export data it gets exported but if i use EXCELFILE.xlsm the page from where i am exporting just executes half way ,
...