Summer Reading B2G1 Free

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to
for a chance to win.
Privacy Policy

Visit our stores

    Recently Viewed clear list

    Q&A | July 20, 2015

    Jesse Ball: IMG Powell’s Q&A: Jesse Ball

    Describe your latest book. I woke up one day from a sort of daydream with an idea for a book's structure, and for the thread of that book, one... Continue »
    1. $16.80 Sale Hardcover add to wish list

      A Cure for Suicide

      Jesse Ball 9781101870129


On Order

New Trade Paper
Currently out of stock.
Add to Wishlist
available for shipping or prepaid pickup only
Qty Store Section
- Local Warehouse Software Engineering- General

This title in other editions

Visual Studio Tools for Office: Using Visual Basic 2005 with Excel, Word, Outlook, and Infopath


Visual Studio Tools for Office: Using Visual Basic 2005 with Excel, Word, Outlook, and Infopath Cover




In 2002, the first release of Visual Studio .NET and the .NET Framework was nearing completion. A few of us at Microsoft realized that Office programming was going to miss the .NET wave unless we did something about it.

What had come before was Visual Basic for Applications (VBA), a simple development environment integrated into all the Office applications. Each Office application had a rich object model that was accessed via a technology known as COM. Millions of developers identified themselves as “Office developers” and used VBA and the Office COM object models to do everything from automating repetitive tasks to creating complete business solutions that leveraged the rich features and user interface of Office. These developers realized that their users were spending their days in Office. By building solutions that ran inside Office, they not only made their users happy, but also were able to create solutions that did more and cost less by reusing functionality already available in the Office applications.

Unfortunately, because of some limitations of VBA, Office programming was starting to get a bad rap. Solutions developed in VBA by small workgroups or individuals would gain momentum, and a professional developer would have to take them over and start supporting them. To a professional developer, the VBA environment felt simple and limited, and of course, it enforced a single language: Visual Basic. VBA embedded code in every customized document, which made it hard to fix bugs and update solutions because a bug would get replicated in documents across the enterprise. Security weaknesses in the VBA model led to a rash of worms and macro viruses that made enterprises turn VBA off.

Visual Studio .NET and the .NET Framework provided a way to address all these problems. A huge opportunity existed to not only combine the richness of the new .NET Framework and developer tools with the powerful platform that Office has always provided for developers, but also solve the problems that were plaguing VBA. The result of this realization was Visual Studio Tools for Office (VSTO).

The first version of VSTO was simple, but it accomplished the key goal of letting professional developers use the full power of Visual Studio .NET and the .NET Framework to put code behind Excel 2003 and Word 2003 documents and templates. It let professional developers develop Office solutions in Visual Basic 2005 and C#. It solved the problem of embedded code by linking a document to a .NET assembly instead of embedding the .NET assembly in the document. It also introduced a new security model that used .NET code-access security to prevent worms and macro viruses.

The second version of VSTO, known as VSTO 2005—the version of VSTO covered by this book—is even more ambitious. It brings with it functionality never before available to the Office developer, such as data binding and data/view separation, design-time views of Excel and Word documents inside Visual Studio, rich support for Windows Forms controls in the document, the ability to create custom Office task panes, server-side programming support against Office—and thats just scratching the surface. Although the primary target of VSTO is the professional developer, that does not mean that building an Office solution with VSTO is rocket science. VSTO makes it possible to create very rich applications with just a few lines of code.

This book tries to put into one place all the information you need to succeed using VSTO to program against Word 2003, Excel 2003, Outlook 2003, and InfoPath 2003. It introduces the Office object models and covers the most commonly used objects in those object models. In addition, this book will help you avoid some pitfalls that result from the COM origins of the Office object models. (Complete Visual Basic 2005 code samples are available on the books Web page at

This book also provides an insider view of all the rich features of VSTO. We participated in the design and implementation of many of these features. We can, therefore, speak from the unique perspective of living and breathing VSTO for the past three years. Programming Office using VSTO is powerful and fun. We hope you enjoy using VSTO as much as we enjoyed writing about it and creating it.

Product Details

Carter, Eric
Addison-Wesley Professional
Lippert, Eric
Programming - Software Development
BASIC (Computer program language)
Business Software - MSOffice
Software Development & Engineering - General
Software Engineering-General
Edition Description:
Trade paper
Microsoft .Net Development
Publication Date:
April 2006
Grade Level:
Professional and scholarly
9 x 6.9 x 2 in 1474 gr

Related Subjects

Computers and Internet » Computer Languages » BASIC
Computers and Internet » Operating Systems » Microsoft Windows » Visual Studio
Computers and Internet » Personal Computers » Desktop Applications » Suites
Computers and Internet » Software Engineering » General

Visual Studio Tools for Office: Using Visual Basic 2005 with Excel, Word, Outlook, and Infopath New Trade Paper
0 stars - 0 reviews
$49.50 Backorder
Product details 1120 pages Addison-Wesley Professional - English 9780321411754 Reviews:
  • back to top


Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at