View Light

Re: Definite mind-twister for an Excel expert to try and sol

Parent Message
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.
Rating: (You must be logged in to vote)