Excel Event Handlers

Question

Hello all, I am trying to initiate the edit of an Excel Workbook from within my applicattion and then intercept the Window Deactivate event. The opening of the Workbook works fine. But I keep getting an An unhandled exception of type 'System.InvalidCastException' occurred in interop.excel.dll Additional information: No such interface supported error during runtime for the line theExcelApp.WindowDeactivate += new Excel.AppEvents_WindowDeactivateEventHandler(ExcelWindow_Deactivate); I am using the Visual Studio IDE and it provided me with the EventHandler designation. I am at a loss. If anybody can tell me the proper way of assigning an EventHandler to an Excel Application Event, I would be much obliged.

Answer 1

Hi, To retrevie infromation from a usercontrol form from the save button which is in another user control what we can do is When the save button is clicked find the parent control of the save button, then using the parent control instance find out the form user control instance from that u can get the information. For example Let me have 2 user control the first user control the as an input as Name textbox and age textbox and another user control has an display button in another usercontrol To retervie the information and display when the display button is clicked private void btnDisplay_Click(object sender, System.EventArgs e) { //Finds out the panel control since the usercontrol is placed in a panel System.Web.UI.Control ct = this.Parent.FindControl("p1"); if(ct != null) { //Find out entry(form control) control System.Web.UI.Control ef = ct.FindControl("entry1"); if(ef != null) { //Find out the textbox control which is in form in turn which is place in a panel System.Web.UI.Control tb = ef.FindControl("txtName"); Response.Write(((TextBox)tb).Text); } else Response.Write("Entry form Box not found"); } else Response.Write("Control not found"); } If you want the entire program give me ur email id. Thanks edward prakash