gistfile1.txt

    public class MyCom : ExcelDna.Integration.CustomUI.ExcelComAddIn
    {
	public MyCom()
        {
        }
        public void OnConnection(object Application, ext_ConnectMode ConnectMode, object AddInInst, ref Array custom)
        {
        }
        public void OnDisconnection(ext_DisconnectMode RemoveMode, ref Array custom)
        {
        }
        public void OnAddInsUpdate(ref Array custom)
        {
        }
        public void OnStartupComplete(ref Array custom)
        {
        }
        public void OnBeginShutdown(ref Array custom)
        {
        }
    }


    public class AddIn : IExcelAddIn
    {
        private ExcelDna.Integration.CustomUI.ExcelComAddIn com_addin;

        public AddIn()
        {
        }

        public void AutoOpen()
        {
            com_addin = new MyCom();
            ExcelDna.Integration.CustomUI.ExcelComAddInHelper.LoadComAddIn(com_addin);
        }

        public void AutoClose()
        {
        }

    }