Apress

Pro Office 2007 Development with VSTO

By Ty Anderson

Pro Office 2007 Development with VSTO Cover Image

Experienced author Ty Anderson cuts to the chase in explaining how professional Microsoft Office 2007 solution developers get the job done.

Full Description

  • ISBN13: 978-1-4302-1072-6
  • User Level: Beginner to Advanced
  • Publication Date: November 20, 2008
  • Available eBook Formats: PDF
  • Print Book Price: $49.99
  • eBook Price: $34.99
Buy eBook Buy Print Book Add to Wishlist

Related Titles

Full Description

Experienced author Ty Anderson cuts to the chase in explaining how professional Microsoft Office 2007 solution developers get the job done. Ty is a professional Microsoft application developer working each and every day with the Visual Studio Tools for Office (VSTO) technology, and his real–world experience will teach you exactly what you need to know to excel in your professional development career.

Pro Office 2007 Development with VSTO takes you far beyond traditional Visual Basic for Applications (VBA) programming, showing you how to transform Microsoft Office 2007 into a complete enterprise application development platform. By the end of the book, you will be creating your own powerful, customized Office business applications (OBAs), using the techniques Ty has taught you throughout. The author demonstrates how to leverage all aspects of the Microsoft Office application platform (covering Word, Excel, Outlook, PowerPoint, Visio, and InfoPath) so you can create OBAs that increase information worker productivity, unlock business data stored in documents, reduce end–user training costs, increase developer productivity, and reduce IT operations costs.

This book takes you beyond the basics of VSTO with expert topics such as automation with the Office application object models and includes detailed examples throughout.

What you’ll learn

  • Understand and leverage Microsoft Office application object models.
  • Build Microsoft Office application–level add–ins.
  • Create and publish document–level add–ins.
  • Integrate external data into Office applications and documents.
  • Integrate SharePoint data with Office.
  • Build workflows.
  • Perform deployments of your solutions and manage delivery of updates.

Who this book is for

This book is for professional Microsoft Office application developers (and those aspiring to be so) who are interested in creating enterprise applications on the solid base of Microsoft Office 2007. The complexity of the examples assumes an intermediate–to–advanced level of experience with Microsoft .NET. Proficient VBA developers wishing to take their skills to the next level will also benefit by this book.

Source Code/Downloads

Downloads are available to accompany this book.

Your operating system can likely extract zipped downloads automatically, but you may require software such as WinZip for PC, or StuffIt on a Mac.

Errata

If you think that you've found an error in this book, please let us know about it. You will find any confirmed erratum below, so you can check if your concern has already been addressed.

* Required Fields

On page Listing 4-13:
I'm not an expert but:

Issue 1:

The "CompanyListBox" becomes suddenly the "CompanyComboBox"...

Issue 2:
There is also no line of code in Listing 4-13 which does the following: "The event method reads the Text property of the CompanyListBox control and inserts it as the value of the CustomerName NamedRange control".

I cannot see the page number in the format presented on Books24x7 but I'm talking about Listing 4-13:

Here is the code pasted from Books24x7:
The CompanyComboBox_SelectedIndexChanged Method
When you select a company using the CompanyComboBox, you want to take a couple of actions. First, you want to update the NamedRange control in the worksheet to display the value you selected. Second, you want to call a custom procedure that queries the Northwind database and updates the OrderSummary ListObject control. Listing 4-13 shows you how to do this.

Listing 4-13: The CompanyComboBox_SelectedIndexChange Method

--------------------------------------------------------------------------------

Private Sub CompanyComboBox_SelectedIndexChanged(ByVal sender _
As System.Object, ByVal e As System.EventArgs) _
Handles CompanyComboBox.SelectedIndexChanged


GetOrderData(False)
End Sub

--------------------------------------------------------------------------------

The event method reads the Text property of the CompanyListBox control and inserts it as the value of the CustomerName NamedRange control. Then the procedure calls the GetOrderData method.