The trick is to create a 'template' XLS workbook with a blank worksheet that contains the VBA Macro code in it. You then generate the spreadsheet with data (but no code) from VB.NET/ASP.NET, then copy the generated spreadsheet into the template workbook, then SaveAs the template to the desired filename so that the original template is unaffected.