private void ThisAddIn_Startup(object sender, EventArgs e)
{
GeneralRep.Initialize(Globals.ThisAddIn.Application, "Excel2010");
if (GeneralRep.IsActivated)
{
GeneralRep.Application.WorkbookOpen += OnWorkbookOpen;
GeneralRep.Application.WorkbookActivate += OnWorkbookChange;
GeneralRep.Application.WorkbookBeforeClose += OnWorkbookClose;
}
}
private void butAddLink_Click(object sender, RibbonControlEventArgs e)
{
GeneralRep.RunReporterCommand(ReporterCommand.PutLinks);
}
private void butDeleteLinks_Click(object sender, RibbonControlEventArgs e)
{
GeneralRep.RunReporterCommand(ReporterCommand.DeleteLinks);
}
private void buttonSetup_Click(object sender, RibbonControlEventArgs e)
{
GeneralRep.RunReporterCommand(ReporterCommand.Setup);
}
private void buttonNewReport_Click(object sender, RibbonControlEventArgs e)
{
GeneralRep.RunReporterCommand(ReporterCommand.Create);
}
private void ThisAddIn_Shutdown(object sender, System.EventArgs e)
{
GeneralRep.Close();
}
//Обработка события по закрытию текущей книги
private void OnWorkbookClose(Workbook workbook, ref bool flag)
{
GeneralRep.CloseBook();
}
//Обработка события по изменению текущей книги
private void OnWorkbookChange(Workbook workbook)
{
GeneralRep.ChangeActiveBook();
}
