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

You are creating a customized Microsoft Office Excel workbook by using the Visual Studio Tools for the Microsoft Office System (VSTO). The data in the Excel workbook will be used to update a Microsoft Office Word report named MyDoc.doc. The MyDoc.doc report is located in the C:\ folder. You need to retrieve a Document object that sends updates from the Excel workbook to the Mydoc.doc report. Which code segment should you use?

• A. Dim app As Word.Application = New Word.Application() Dim filename As Object = "C:\MyDoc.doc" Dim temp As Object = app.Documents.Open(FileName:=filename) Dim doc As Word.Document = app.Documents.Add(temp)
• B. Dim app As Word.Application = New Word.Application() Dim filename As Object = "C:\MyDoc.doc" Dim doc As Word.Document = _ app.Documents.Open(FileName:=filename)
• C. Dim app As Word.Application = New Word.Application() Dim filename As Object = "C:\MyDoc.doc" Dim temp As Object = Nothing app.Documents.Open(FileName:=filename, ConfirmConversions:=temp) Dim doc As Word.Document = CType(temp, Word.Document)
• D. Dim app As Word.Application = New Word.Application() Dim filename As Object = "C:\MyDoc.doc" Dim action As Object = "Open" Dim doc As Word.Document = _ app.Documents.Add(Template:=filename, NewTemplate:=action)

You create a custom template for Microsoft Office Word 2007 by using Visual Studio Tools for the Microsoft Office System (VSTO). You add a content control to the custom template. The content control is a placeholder for the first paragraph in the documents that use the custom template. You need to ensure that the users can edit the first paragraph but cannot delete it. Which code segment should you use?

• A. control.LockContentControl = True control.LockContents = False
• B. control.LockContentControl = False control.LockContents = False
• C. control.LockContentControl = False control.LockContents = True
• D. control.LockContentControl = True control.LockContents = True

You create an add-in for Microsoft Office Word 2007 by using Visual Studio Tools for the Microsoft Office System (VSTO). The add-in contains code that customizes the Ribbon user interface (UI). You run the add-in. The add-in does not customize the Ribbon UI and does not display an exception. You need to display the exceptions in the user interface of the add-in when the add-in starts. What should you do?

• A. Add a new application configuration file to your project by using the following XML
  fragment.
  < configuration > < appSettings > < add key="ShowErrors" value="True"/ > < /appSettings > < /configuration >
• B. In the Configuration Manager dialog box for the add-in project, set Active Configuration to Debug.
• C. Under the Word 2007 options, select the Show add-in user interface errors check box.
• D. Add a new application configuration file to your project by using the following XML fragment. < configuration > < appSettings > < add key="Debug" value="True"/ > < /appSettings > < /configuration >

You are creating an add-in for Microsoft Office Excel 2007 by using Visual Studio Tools for the Microsoft Office System (VSTO). You write the following code segment for the add-in class.
Dim pane As Microsoft.Office.Tools.CustomTaskPane
Private Sub CreatePane ()
Pane = Me.CustomTaskPanes.Add (New MyUserControl (), _
"Do Something")
pane.Visible = True
End Sub
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 Application.WorkbookOpen event. Private Sub Application_WorkbookOpen ( ByVal Wb As Excel.Workbook ) CreatePane () End Sub
• B. Create the following event handler for the Application.WindowActivate event. Private Sub Application_WindowActivate _ ( ByVal Wb As Excel.Workbook , ByVal Wn As Excel.Window ) CreatePane () End Sub
• C. Create the following event handler for the ThisAddIn.StartUp event. Private Sub ThisAddIn_Startup _ ( ByVal sender As Object, ByVal e As System.EventArgs ) CreatePane () End Sub
• D. Create the following event handler for the Application.WorkbookActivate event. Private Sub Application_WorkbookActivate _ ( ByVal Wb As Excel.Workbook ) CreatePane () End Sub

You are creating an add-in for Microsoft Office Excel by using Visual Studio Tools for the Microsoft Office System (VSTO). The add-in contains a server document named doc. The add-in also contains a variable named filepath that will store the location of an XML file. You need to load the XML file into the document cache. Which code segment should you use?

• A. StreamReader sr = new StreamReader(filepath); doc.CachedData.HostItems.Add(sr.ReadToEnd());
• B. StreamReader sr = new StreamReader(filepath); doc.CachedData.FromXml(sr.ReadToEnd());
• C. doc.CachedData.HostItems.Add(filepath);
• D. doc.CachedData.FromXml(filepath);