Mega Code Archive

 

Categories / C# / Office

 

Using Office Events

/*  * C# Programmers Pocket Consultant  * Author: Gregory S. MacBeth  * Email: gmacbeth@comporium.net  * Create Date: June 27, 2003  * Last Modified Date:  * Version: 1  */ using System; using Excel; using System.Reflection; namespace Client.Chapter_19___Office_Integration {   public class UsingOfficeEvents   {     public static AppEvents_WorkbookBeforeCloseEventHandler Event_BeforeBookClose;     public static DocEvents_ChangeEventHandler Event_ChangeEvent;     static void Main(string[] args)     {       Application MyExcel = new ApplicationClass();       Workbook MyWorkbook = MyExcel.Workbooks.Add(Missing.Value);       MyWorkbook.Windows.get_Item(1).Caption = "Using Delegates";       Worksheet MyWorksheet1 = (Worksheet)MyWorkbook.Worksheets.get_Item(1);       Worksheet MyWorksheet2 = (Worksheet)MyWorkbook.Worksheets.get_Item(2);       Worksheet MyWorksheet3 = (Worksheet)MyWorkbook.Worksheets.get_Item(3);       MyWorksheet1.Activate();       //Add Event Handler for the BeforeClose Event       Event_BeforeBookClose = new AppEvents_WorkbookBeforeCloseEventHandler(BeforeBookClose);       MyExcel.WorkbookBeforeClose += Event_BeforeBookClose;       //Add Event Handler for the change Event       Event_ChangeEvent = new DocEvents_ChangeEventHandler(CellChange);       MyWorksheet1.Change += Event_ChangeEvent;       MyWorksheet2.Change += Event_ChangeEvent;       MyWorksheet3.Change += Event_ChangeEvent;       MyExcel.Visible = true;       MyExcel.UserControl = true;     }     private static void CellChange(Range Target)     {       //Gets called when you change a cell     }     private static void BeforeBookClose(Workbook MyWorkbook, ref bool Cancel)     {       //Gets called before closing a workbook     }   } }