Excel Development through .Net losing Macros

Question

Good Afternoon,

I have a an Excel template file - which contains Macros - that I load up in .Net. The excel document is built up on a case by case basis (the same format, but with different data dependent on what the user picks). When the Excel document is loaded up, the Macros have disappeared, does anyone know why and how to resolve the problem?

Thanks

Answer 1

If you are using MS Office 2007 you need to take in consideration that Excel Workbook (*.xlsx) do not support macros.

You'll need to save it as Excel Macro-Enabled Workbook (*.xlsm).