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

by Carter, Eric; Lippert, Eric

• ISBN13: 9780132701754
• ISBN10: 0132701758
• Edition: 1st
• Copyright: 2006-04-26
• Publisher: Addison-Wesley Professional

Summary

Visual Studio Tools for Office is both the first and the definitive book on VSTO 2005 programming, written by the inventors of the technology. VSTO is a set of tools that allows professional developers to use the full power of Visual Studio .NET and the .NET Framework to put code behind Excel 2003, Word 2003, Outlook 2003, and InfoPath 2003.

VSTO provides functionality never before available to the Office developer: data binding and data/view separation, design-time views of Excel and Word documents inside Visual Studio, rich support for Windows Forms controls in a document, the ability to create custom Office task panes, server-side programming support against Office, and much more.

Carter and Lippert cover their subject matter with deft insight into the needs of .NET developers learning VSTO. This book

• Explains the architecture of Microsoft Office programming and introduces the object models
• Teaches the three basic patterns of Office solutions: Office automation executables, Office add-ins, and code behind a document
• Explores the ways of customizing Excel, Word, Outlook, and InfoPath, and plumbs the depths of programming with their events and object models
• Introduces the VSTO programming model
• Teaches how to use Windows Forms in VSTO and how to work with the Actions Pane
• Delves into VSTO data programming and server data scenarios
• Explores .NET code security and VSTO deployment

Author Biography

Eric Carter is the development manager of the Visual Studio Tools for Office (VSTO) team at Microsoft. He helped invent, design, and implement many of the features that are in VSTO today. Previously at Microsoft he worked on Visual Studio for Applications, the Visual Studio Macros IDE, and Visual Basic for Applications for Office 2000 and Office 2003.

Eric Lippert’s primary focus during his nine years at Microsoft has been on improving the lives of developers by designing and implementing useful programming languages and development tools. He has worked on the Windows Scripting family of technologies, Visual Studio Tools for Office and, most recently, the new Language Integrated Query features of C# 3.0.

Table of Contents

Figures xxxi

Tables xlv

Foreword xlix

Preface liii

Acknowledgments lvii

About the Authors lix

Part I: An Introduction to VSTO 1

Chapter 1: An Introduction to Office Programming 3

Why Office Programming? 3

Office Object Models 6

Properties, Methods, and Events 12

The Office Primary Interop Assemblies (PIAs) 34

Conclusion 43

Chapter 2: Introduction to Office Solutions 45

The Three Basic Patterns of Office Solutions 45

Office Automation Executables 49

Office Add-Ins 60

Code Behind a Document 65

Conclusion 72

Part II: Office Programming in .NET 73

Chapter 3: Programming Excel 75

Ways to Customize Excel 75

Programming User-Defined Functions 83

Introduction to the Excel Object Model 92

Conclusion 98

Chapter 4: Working with Excel Events 99

Events in the Excel Object Model 99

Events in Visual Studio 2005 Tools for Office 138

Conclusion 142

Chapter 5: Working with Excel Objects 143

Working with the Application Object 143

Working with the Workbooks Collection 157

Working with the Workbook Object 161

Working with the Worksheets, Charts, and Sheets Collections 169

Working with Document Properties 172

Working with the Windows Collections 175

Working with the Window Object 179

Working with the Names Collection and Name Object 181

Working with the Worksheet Object 183

Working with the Range Object 197

Special Excel Issues 213

Conclusion 220

Chapter 6: Programming Word 223

Ways to Customize Word 223

Programming Research Services 229

Introduction to the Word Object Model 237

Conclusion 238

Chapter 7: Working with Word Events 243

Events in the Word Object Model 243

Why Are There Multiple Application and Document Event Interfaces? 244

Events in Visual Studio Tools for Office 273

Conclusion 275

Chapter 8: Working with Word Objects 277

Working with the Application Object 277

Working with the Dialog Object 299

Working with Windows 304

Working with Templates 307

Working with Documents 310

Working with a Document 315

Working with the Range Object 335

Working with Bookmarks 358

Working with Tables 360

Conclusion 362

Chapter 9: Programming Outlook 363

Ways to Customize Outlook 363

Custom Property Pages 370

Introduction to the Outlook Object Model 378

Introduction to the Collaboration Data Objects 382

Conclusion 386

Chapter 10: Working with Outlook Events 387

Events in the Outlook Object Model 387

Application-Level Events 392

Outlook Item Events 405

Other Events 419

Conclusion 422

Chapter 11: Working with Outlook Objects 423

Working with the Application Object 423

Working with the Explorers and Inspectors Collections 431

Working with the Explorer Object 433

Working with the Inspector Object 440

Working with the NameSpace Object 443

Working with the MAPIFolder Object 450

Working with the Items Collection 459

Properties and Methods Common to Outlook Items 466

Outlook Issues 486

Conclusion 492

Chapter 12: Introduction to InfoPath 493

What Is InfoPath? 493

Getting Started 494

Form Security 499

Programming InfoPath 505

Data Source Events 509

Form Events, Properties, and Methods 518

Conclusion 529

Part III: Office Programming in VSTO 531

Chapter 13: The VSTO Programming Model 533

The VSTO Programming Model 533

VSTO Extensions to Word and Excel Objects 536

Dynamic Controls 542

Inspecting the Generated Code 549

VSTO Extensions to the Word and Excel Object Models 555

Conclusion 569

Chapter 14: Using Windows Forms in VSTO 571

Introduction 571

Adding Windows Forms Controls to Your Document 577

Writing Code Behind a Control 584

The Windows Forms Control Hosting Architecture 585

Properties Merged from OLEObject or OLEControl 594

Adding Controls at Runtime 597

Conclusion 605

Chapter 15: Working with the Actions Pane 607

Introduction to the Actions Pane 607

Working with the ActionsPane Control 613

Conclusion 628

Chapter 16: Working with Smart Tags in VSTO 629

Introduction to Smart Tags 629

Creating Document-Level Smart Tags with VSTO 633

Creating Application-Level Smart Tags 647

Conclusion 672

Chapter 17: VSTO Data Programming 673

Creating a Data-Bound Customized Spreadsheet with VSTO 673

Creating a Data-Bound Customized Word Document with VSTO 681

Datasets, Adapters, and Sources 682

Another Technique for Creating Data-Bound Spreadsheets 691

Caching Data in the Data Island 699

Advanced ADO.NET Data Binding: Looking Behind the Scenes 704

Binding-Related Extensions to Host Items and Host Controls 705

Conclusion 712

Chapter 18: Server Data Scenarios 713

Populating a Document with Data on the Server 713

Using ServerDocument and ASP.NET 716

A Handy Client-Side ServerDocument Utility 724

The ServerDocument Object Model 726

Conclusion 737

Chapter 19: .NET Code Security 739

Code-Access Security Versus Role-Based Security 740

Code-Access Security in .NET 741

Location, Location, Location 749

Strong Names 753

Publisher Certificates 761

Trusting the Document 765

Deploying Policy to User Machines 769

Conclusion 773

Chapter 20: Deployment 775

VSTO Prerequisites 776

Deploying to an Intranet Shared Directory or Web Site 777

Local Machine Deployment Without a Deployment Manifest 785

Editing Manifests 787

Creating Setup Packages 793

Conclusion 805

Part IV: Advanced Office Programming 807

Chapter 21: Working with XML in Excel 809

Introduction to Excel’s XML Features 809

Introduction to XML Schema Creation in Visual Studio 811

An End-to-End Scenario 816

Advanced XML Features in Excel 826

Excel-Friendly XML Schemas 830

VSTO Support for Excel Schema Mapping 833

Conclusion 849

Chapter 22: Working with XML in Word 851

Introduction to Word’s XML Features 851

An End-to-End Scenario: Creating a Schema and Mapping It into a Word Document 855

Exporting the Mapped XML in the Document to an XML Data File 869

Importing an XML Data File into the Mapped Document 871

The XML Options Dialog Box 877

VSTO Support for Word Schema Mapping 880

VSTO Support for the WordML File Format 888

Conclusion 889

Chapter 23: Developing COM Add-Ins for Word and Excel 891

Introduction to Add-Ins 891

Scenarios for Using Add-Ins 892

How a COM Add-In Is Registered 893

Implementing IDTExtensibility2 897

Writing a COM Add-In Using Visual Studio 904

The Pitfalls of mscoree.dll 914

COM Interop and regasm.exe 914

Shimming: A Solution to the Problems with mscoree.dll 919

Conclusion 920

Chapter 24: Creating Outlook Add-Ins with VSTO 921

Moving Away from COM Add-Ins 921

Creating an Outlook Add-In in VSTO 933

Conclusion 940

Bibliography 941

Index 943