Excel DNA could not open blank worksheet by default

Jul 11, 2014 at 3:54 AM
Excel DNA could not open blank worksheet by default , it shows blank work book when doble click on .xll
Here I want to open blank worksheet by default in which i can write some data.
Coordinator
Jul 11, 2014 at 10:35 AM
If your add-in has a public class the implements ExcelDna.Integration.IExcelAddIn, you can put some code in the AutoOpen() that will check whether there is a book open, and make a new one if not.

Easiest is to use the COM object model for this, starting with the Application object you get from ExcelDnaUtil.Application. Either use dynamic or add a reference to the Microsoft.Office.Interop.Excel interop assembly.

-Govert