TS-Visual-Studio-Tools-for-2007-MS-Office-System-VTSO-Csharp-(70-543-CSharp).pdf

This preview shows page 1 - 3 out of 6 pages.

70-543-CSharp Microsoft TS- Visual Studio Tools for 2007 MS Office System (VTSO)
QUESTION: 54 You are creating an add-in for Microsoft Office Excel 2007 by using Visual Studio Tools You write the following code segment for the . ) VSTO ( for the Microsoft Office System add-in class. Microsoft.Office.Tools.CustomTaskPane pane; private void CreatePane () { pane = this.CustomTaskPanes.Add (new MyUserControl (), "Do Something"); pane.Visible = true; } Users must open multiple workbooks in Excel. You need to ensure that the add-in displays the same instance of the task pane when a user views any of the open workbooks. What should you do? . A Create the following event handler for the . StartUp event . ThisAddIn ThisAddIn_Startup(object sender, System.EventArgs e) { CreatePane (); } B. Create the following event handler for the Application.WorkbookOpen event. Void Workbook Wb ) { CreatePane (); } . Application_WorkbookOpen ( Excel C. Create the following event handler for the Application.WorkbookActivate event. Void Workbook Wb ) { CreatePane (); } . Application_WorkbookActivate ( Excel D. Create the following event handler for the Application.WindowActivate event. Void Window Wn ) { CreatePane (); . Excel , Workbook Wb . Application_WindowActivate ( Excel } void
QUESTION: 55 You develop an add-in for Microsoft Office Excel by using Visual Studio Tools for the Microsoft Office System (VSTO). The add-in contains a class that uses the following method. public void ProcessCells() { Excel.Worksheet ws = Application.ActiveSheet as Excel.Worksheet; List<object> values = new List<object>(); //Your code goes here } The add-in must retrieve the values for the cells in the range A1 through E3. You need to

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture