Not sure whether TestSimulate is the right fit? Download the free PDF demo of the 70-543 practice questions and judge the quality of our Microsoft TS: Visual Studio Tools for 2007 MS Office System (VTSO) material before you spend anything.

Microsoft 70-543 Exam Overview:

Microsoft 70-543 Exam Syllabus Topics:

Microsoft TS: Visual Studio Tools for 2007 MS Office System (VTSO) FAQ: What Candidates Ask Most

Microsoft TS: Visual Studio Tools for 2007 MS Office System (VTSO) Sample Questions:

Question 1

You create an application by using Visual Studio Tools for the Microsoft Office System (VSTO). The application modifies a Microsoft Office Excel custom workbook. The custom workbook displays the data that is contained in an XML file named Salesorder.xml. The Salesorder.xml file uses an XML schema that is stored in a file named Salesorder.xsd. Both the Salesorder.xml file and the Salesorder.xsd file are located in the C:\Data folder. You need to ensure that the data in the Salesorder.xml file is available for mapping. Which code segment should you use?

A. Excel.XmlMap map = this.XmlMaps.Add (@"c:\data\Salesorder.xsd", "Root"); this.XmlImport (@"c:\data\Salesorder.xml", out map, true, Globals.Sheet1.Range["A1", Type.Missing ]);
B. Excel.XmlMap map = this.XmlMaps.Add (@"c:\data\Salesorder.xsd", "Root"); this.XmlImportXml (@"c:\data\Salesorder.xml", out map, true, Globals.Sheet1.Range["A1", Type.Missing ]);
C. Excel.XmlMap map = this.XmlMaps.Add (@"c:\data\Salesorder.xml", "Root"); this.XmlImportXml (@"c:\data\Salesorder.xsd", out map, false, Globals.Sheet1.Range["A1", Type.Missing ]);
D. Excel.XmlMap map = this.XmlMaps.Add (@"c:\data\Salesorder.xml", "Root"); this.XmlImport (@"c:\data\Salesorder.xsd", out map, false, Globals.Sheet1.Range["A1", Type.Missing ]);

Question 2

You are creating an add-in for Microsoft Office Outlook 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 Private folders As List(Of Outlook.MAPIFolder)
02 Private explorer As Outlook.Explorer
03
04 Public Sub CreateCollection()
05 explorer = Application.ActiveExplorer()
06 folders = New List(Of Outlook.MAPIFolder)
07 ProcessFolders(explorer.CurrentFolder)
08 End Sub
09
10 Public Sub ProcessFolders(ByVal folder As Outlook.MAPIFolder)
11 ...
12 End Sub
You need to ensure that the folders collection includes all the folders and subfolders within the selected Outlook folder.
Which code segment should you insert at line 11?

A. For Each fldr As Outlook.MAPIFolder In folder.Folders ProcessFolders(fldr) Next
B. For Each fldr As Outlook.MAPIFolder In folder.Folders folders.Add(fldr) Next You are creating a document-level solution for Microsoft Office Word 2003 by using Visual Studio Tools for the Microsoft Office System (VSTO).
C. For Each fldr As Outlook.MAPIFolder In folder.Folders
D. folders.AddRange(folder.Folders) ProcessFolders(fldr) Next folders.Add(fldr)

Question 3

You create a document-level solution for Microsoft Office Word 2003 by using Visual Studio Tools for the Microsoft Office System (VSTO). You create a user control named MyUserControl.
You write the following code segment for your document class. (Line numbers are included for reference only.)
01 Private Sub ThisDocument_Startup _
(ByVal sender As Object, ByVal e As System.EventArgs)
02 Dim uc As MyUserControl = New MyUserControl()
03 ... 04 End Sub
You need to display userControl in the actions pane.
Which code segment should you insert at line 03?

A. Me.ActionsPane.Parent.Controls.Add(uc)
B. Me.ActionsPane.Controls.AddRange _ (New Control() {uc, New MyUserControl()})
C. Me.ActionsPane.Controls.Add(uc)
D. Me.Controls.AddControl(uc, 100, 100, 100, 100, "Action s Pane")

Question 4

You are creating a document-level solution for Microsoft Office Word 2003 by using Visual Studio Tools for the Microsoft Office System (VSTO).
You write the following lines of code in the solution.
Dim tag As SmartTag = New _
SmartTag("http:// MySmartTag/ST#MySmartTag", "My Tag") tag.Terms.Add("Bug") tag.Terms.Add("Error") tag.Terms.Add("Issue") Dim action As Action = New Action("Add Reference") tag.Actions = New ActionBase() {action} AddHandler action.Click, AddressOf Me.action_Click
You need to add the string "Reference: " before either "Bug", "Error", or "Issue" when the smart tag is clicked.
Which code segment should you use?

A. Private Sub action_Click ( _ ByVal sender As Object, ByVal e As ActionEventArgs ) e.Range.Text = "Reference: " & e.Text End Sub
B. Private Sub action_Click ( _ ByVal sender As Object, ByVal e As ActionEventArgs ) e.Range.Text = "Reference: " & e.Range.XML (False).ToString() End Sub
C. Private Sub action_Click ( _ ByVal sender As Object, ByVal e As ActionEventArgs ) e.Range.Text = "Reference: " & e.Properties.Read ("Text") End Sub
D. Private Sub action_Click ( _ ByVal sender As Object, ByVal e As ActionEventArgs ) e.Properties.Write ( e.Range.Text , "Reference: " & e.Range.Text ) End Sub

Question 5

You create a document-level solution for Microsoft Office Excel 2003 by using Visual Studio Tools for the Microsoft Office System (VSTO). The customized worksheet must have a button in a cell of the first row and the first column. The button must be automatically resized when the cell is resized. You need to create a button that meets the requirements. Which code segment should you use?

A. Excel.Range rng = Sheet.Range["A", "1"]; Sheet.Controls.AddButton(rng, "MyButton");
B. Button button = Sheet.Controls.AddButton(1, 1, 0, 0, "MyButton"); button.Dock = DockStyle.Fill;
C. Button button = Sheet.Controls.AddButton(1, 1, 1, 1, "MyButton"); button.Dock = DockStyle.None;
D. Excel.Range rng = Sheet.Range["A1", System.Type.Missing ]; Sheet.Controls.AddButton(rng, "MyButton");

Solutions: