Also please make sure the macro is enabled in the excel
To enable macro go to any excelfile then go to file>Options>Trust Center>Trust Center settings> Macro setting> enable all macro