Microsoft 70-543 : TS: Visual Studio Tools for 2007 MS Office System (VTSO)

You are creating a custom template for Microsoft Office Word 2007 by using Visual Studio Tools for the Microsoft Office System (VSTO).
The template contains a custom XML part that consumes data from an XML source. The XML source contains the following XML fragment.
<Products> mother board, memory, hard drive,
floppy drive, DVD drive </Products>
You need to display the Products element as a comma-separated list within a paragraph of text.
Which code segment should you use?

• A. Application.ActiveDocument.ContentControls.Add ( WdContentControlType.wdContentControlDropdownList , ref range);
• B. Application.ActiveDocument.ContentControls.Add ( WdContentControlType.wdContentControlText , ref range);
• C. Application.ActiveDocument.ContentControls.Add ( WdContentControlType.wdContentControlComboBox , ref range);
• D. Application.ActiveDocument.ContentControls.Add ( WdContentControlType.wdContentControlRichText , ref range);

You create a document-level solution for Microsoft Office 2003 by using Visual Studio Tools for the Microsoft Office System (VSTO). You publish the solution to a folder on a network share. You copy a new version of the solution to a subfolder of the folder. You need to ensure that the users are redirected to the new version of the solution when they open the solution from the network share. What should you do?

• A. Change the application manifest in the main folder of the published solution to point to the new version.
• B. Change the deployment manifest in the main folder of the published solution to point to the new version.
• C. Create a deployment manifest in the subfolder. Edit the deployment manifest in the subfolder to point to the new version.
• D. Create an application manifest in the subfolder. Edit the application manifest in the subfolder to point to the new version.

You are creating an add-in for Microsoft Office Word 2007 by using Visual Studio Tools for the Microsoft Office System (VSTO). You write the following lines of code.
Private Pane As Microsoft.Office.Tools.CustomTaskPane
Private Sub ThisAddIn_Startup _
(ByVal sender As Object, ByVal e As System.EventArgs)
Pane = Me.CustomTaskPanes.Add _
(New MyUserControl(), "Do Something")
End Sub
You need to display the custom task pane when text is selected in a Word document.
What should you do?

• A. Create the following event handler for the Application.WindowSelectionChange event. Private Sub Application_WindowSelectionChange(ByVal Sel As Word.Selection) If Sel.Start = Sel.End Then Pane.Visible = False Else Pane.Visible = True End If End Sub
• B. Create the following event handler for the Pane.VisibleChanged event. Private Sub Pane_VisibleChanged _ (ByVal sender As Object, ByVal e As EventArgs) Dim Doc As Word.Document = Application.ActiveDocument If Doc.Content.Text.Length > 0 Then Pane.Visible = False Else Pane.Visible = True End If End Sub
• C. Create the following event handler for the Application.DocumentChange event. Private Sub Application_DocumentChange() Dim Doc As Word.Document = Application.ActiveDocument If Doc.Content.Text.Length > 0 Then Pane.Visible = False Else Pane.Visible = True End If End Sub
• D. Create the following event handler for the Application.WindowActivate event. Private Sub Application_WindowActivate _ (ByVal Doc As Word.Document, ByVal Wn As Word.Window) If Doc.Content.Text.Length > 0 Then Pane.Visible = False Else Pane.Visible = True End If End Sub

You develop a document-level solution for Microsoft Office Excel 2003 by using Visual Studio Tools for the Microsoft Office System (VSTO).
You write the following lines of code in the worksheet class.
Private Sub Handle_Change ( ByVal Target As Excel .Range )
...
End Sub
You need to ensure that the Handle_Change method runs only when the data in the range A1 through E5 changes.
Which code segment should you add to the Startup event of the worksheet class?

• A. Dim rng As Excel.Range = Me.Range ("A1", "E5") AddHandler Change, AddressOf Me.Handle_Change
• B. Dim rng As Excel.Range = Me.Range ("A1", "E5") Dim rng1 As Microsoft.Office.Tools.Excel.NamedRange = _ Me.Controls.AddNamedRange ( rng , " MyRange ") AddHandler rng1.SelectionChange, AddressOf Me.Handle_Change
• C. Dim rng As Excel.Range = Me.Range ("A1", "E5") Dim rng1 As Microsoft.Office.Tools.Excel.NamedRange = _ Me.Controls.AddNamedRange ( rng , " MyRange ") AddHandler rng1.Change, AddressOf Me.Handle_Change
• D. Dim rng As Excel.Range = Me.Range ("A1", "E5") AddHandler SelectionChange , AddressOf Me.Handle_Change

You create an add-in for Microsoft Office Outlook 2007 by using Visual Studio Tools for the Microsoft Office System (VSTO). You deploy the add-in to a network share named OfficeSolutions. The OfficeSolutions network share is located on a server named LONDON. You need to grant permission for the add-in to run. Which command should you use?

• A. caspol Cm Cag LocalIntranet_zone Curl "\\LONDON\OfficeSolutions" FullTrust
• B. caspol Cm Cgac FullTrust
• C. caspol Cm Cag LocalIntranet_zone Curl "\\LONDON\OfficeSolutions" Execute
• D. caspol Cm Cgac Execute