| Exam Code/Number: | 70-543Join the discussion |
| Exam Name: | TS: Visual Studio Tools for 2007 MS Office System (VTSO) |
| Certification: | Microsoft |
| Question Number: | 120 |
| Publish Date: | Oct 24, 2025 |
|
Rating
100%
|
|
You create an add-in for Microsoft Office Excel 2007 by using Visual Studio Tools for the Microsoft Office System (VSTO). The add-in must be installed on 100 computers that run Windows Vista and Microsoft Office 2007 Professional Edition. You need to configure the computers to run the add-in. What should you install on the computers?
You are creating a document-level solution for Microsoft Office Word 2003 by using Visual Studio Tools for the Microsoft Office System (VSTO).
You create the following objects in the solution:
a DataSet object named AWDataSet that contains two tables named Product and SalesOrderDetail
a BindingSource object named ProductsBindingSource
a bookmark that is bound to the SalesOrderDetail table You need to retrieve the active row from the solution .
Which code segment should you use?
You create a document-level solution for a Microsoft Office Word document by using a Visual Studio Tools for the Microsoft Office System (VSTO) project. The solution project is named HRSolution. The solution document is named HRSolution.doc. You deploy a copy of the solution document to the C:\OfficeSolutions folder on client computers. You deploy the assembly to a shared folder named OfficeSolutions. The shared folder is located on a server named LONDON. You need to ensure that the solution document loads the assembly from the correct location. Which code segment should you use?
You are creating an add-in for Microsoft Office Word by using Visual Studio Tools for the Microsoft Office System (VSTO). You write the following lines of code. (Line numbers are included for reference only.)
01 Try
02 Dim par As Word.Paragraph = _
Me.Application.ActiveDocument.Paragraphs (2)
03 par.Range.Text = ""
04 ...
The application throws an exception if the active Word document does not contain a second paragraph.
You need to handle the exception.
Which code segment should you insert at line 04?
You create a document-level solution for Microsoft Office Excel 2003 by using Visual Studio Tools for the Microsoft Office System (VSTO). The solution creates a NamedRange control named XLNRange in an Excel worksheet. The range contains cells A1 through B3. You bind the XLNRange control to a data table named FactResellerSales by using the Data Source Configuration Wizard. You need to synchronize the FactResellerSales table with the changes that are made to the data in the XLNRange control. Which code segment should you use?
