Microsoft Office XP Developer's Guide Book

	Foreword	xxxiii
Part 1	Getting Started with Office XP Developer	1
	Introduction	1
	What's New in Office XP Developer	5
	Setting up the Developer Design Environment	7
	Setting up the Server Environment	8
Part 2	Developing Office Developer Applications	15
Chapter 1	Designing Applications	17
	The Design Process	17
	Which Technologies Should You Use?	20
	Thinking About User Interface Design	30
	Designing Code for Reusability	31
	Security Considerations	32
	Testing Your Application	33
	Application Deployment	33
Chapter 2	Developing Office Applications Using VBA	35
	The Benefits of Office Programmability	36
	Office Objects and Object Models	37
	Working with Office Applications	75
	Working with Microsoft FrontPage Objects	123
	Working with Microsoft Outlook Objects	127
	Working with Microsoft PowerPoint Objects	139
	Working with Microsoft Project Objects	153
	Working with Microsoft Visio Objects	156
	Working with Microsoft Word Objects	159
	Working with Shared Office Components	186
	Getting the Most Out of Visual Basic for Applications	242
	Add-ins, Templates, Wizards, and Libraries	297
Chapter 3	Developing Workflow Applications for Exchange Server	349
	Workflow Applications Architecture for Exchange Server	350
	Planning a Workflow Process for Exchange Server	357
	Building a Workflow Process for Exchange Server	361
	Developing the User Interface for Exchange Workflow	377
	Scripting in the Workflow Designer for Exchange Server	380
Chapter 4	Developing Workflow Applications for SQL Server	393
	Workflow Applications Architecture for SQL Server	394
	Planning Workflow Applications for SQL Server	400
	Building Workflow Applications for SQL Server	409
	Developing a User Interface for SQL Server	424
	Setting Up Accounts, Logins, Roles, and Users	436
	Scripting Workflow Events for SQL Server	450
	Creating Templates	461
Chapter 5	Developing a Digital Dashboard Using Web Parts	467
	Understanding the Digital Dashboard	467
	Web Parts	472
Chapter 6	Debugging and Error Handling	489
	Writing Error-Free Code	490
	Debugging Code	492
	Handling Errors	498
Chapter 7	Localizing Your Application	509
	Localization Guidelines for Your User Interface	509
	Localization Guidelines for Language and Terminology	511
	Localization Guideline for Your Code	512
	Localizing Your Access Runtime Application	514
Chapter 8	Deploying Your Application	517
	The Packaging Process	517
	Creating a Setup Package Using the Packaging Wizard	518
	Deploying Office Templates and Application-Specific Add-ins	524
	Deploying COM Add-ins	528
	Deploying Outlook and FrontPage Applications	529
	Deploying Microsoft Access Applications using the Access Runtime	529
Part 3	Programming Concepts	537
Chapter 9	Writing Solid Code	539
	Writing Solid Script	539
	Using a Naming Convention	541
	Structuring and Formatting Your Code	550
	Commenting Code	555
	Designing Code to Be Used Again	560
Chapter 10	Working with XML	565
	Office Applications and XML	566
	Working with XML in the Design Environment	572
Chapter 11	Custom Classes and Objects	573
	Why Build Your Own Objects?	574
	Basic Class Concepts	575
	Creating Property Procedures	581
	Creating Events and Event Procedures	588
	Extending Objects Through Interfaces	595
	Designing Object Models	604
	Creating Custom Objects for Web Pages	606
Part 4	Using the Office Developer Productivity Tools	609
Chapter 12	Sharing Code with the Code Librarian	611
	Opening the Code Librarian	611
	Creating a Code Library	612
	Creating Code Librarian Categories	612
	Using Code Snippets from the Code Library	613
	Customizing Code in the Code Librarian	614
	Making the Code Librarian Available to Multiple Users	617
Chapter 13	Using Source Code Control	619
	Setting Up Visual SourceSafe	620
	Choosing the Right Source Code Control Add-In	621
	Using the Visual SourceSafe Add-In with the Visual Basic Environment	622
	Using Visual SourceSafe with Documents and VBA Code	623
	Using Source Control with Access	626
Chapter 14	Sharing and Reusing VBA Objects	627
	Exporting VBA Objects	627
	Importing VBA Objects	628
Chapter 15	Rapid Application Development Tools	629
	Formatting String Variables	629
	Formatting Code Commenter and Error Handler Templates	630
Appendix A	Microsoft Office Developer Walkthroughts	633
Walkthrough 1	Creating a COM Add-in with VBA	635
	Introduction	635
	Configuring the Add-in Designer	635
	Writing Code in the Add-in Designer	636
	Integrating a Command Bar Control into the Add-in	637
	Debugging and Testing the COM Add-in	640
	Making a DLL for the COM Add-in	640
	Troubleshooting Common Add-in Development Problems	641
Walkthrough 2	Creating a Workflow Application Using Exchange Server	643
	Introduction	643
	Preparing Exchange for a Team Application	644
	Creating the User Interface in Outlook	645
	Planning the Workflow	649
	Creating a Workflow Process	652
	Activating the Workflow Process	666
	Using the Workflow Process	666
Walkthrough 3	Developing a Workflow Application Using Workflow Designer for SQL Server	669
	Introduction	669
	Setup Requirements	669
	Building a Workflow Application	670
Walkthrough 4	Creating a Digital Dashboard using Web Parts	689
	Introduction	689
	Preparing the Exchange Server	690
	Creating the Digital Dashboard Project	690
	Adding Web Parts	691
	Previewing and Testing your Dashboard	691
Appendix B	Microsoft Office XP Developer Object Model Guide	693
	Using These Object Model Diagrams	694
	Office XP Applications	695
	Microsoft Access Object Model	695
	Microsoft Excel Object Model	697
	Microsoft FrontPage Object Model	701
	Microsoft MapPoint Object Model	703
	Microsoft Outlook Object Model	704
	Microsoft PowerPoint Object Model	705
	Microsoft Project Object Model	709
	Microsoft Publisher Object Model	710
	Microsoft Visio Object Model	713
	Microsoft Word Object Model	714
	Shared Components	721
	Microsoft Office XP Object Model	721
	Microsoft Graph Object Model	723
	Microsoft Forms Object Model	724
	Visual Basic Editor 6.0 Object Model	725
	Data Access	727
	Microsoft ActiveX Data Objects 2.1 Object Model	727
	Microsoft ADO Extensions 2.1 for DDL and Security Object Model	728
	Microsoft ActiveX Data Objects (Multi-Dimensional) 1.0 Object Model	729
	Microsoft Data Access Objects (DAO) 3.6 Object Library Object Model	730
	Microsoft Jet and Replication Objects 2.1 Library Object Model	731
	Web Technologies	733
	Microsoft Internet Explorer 5 and Document Object Model	733
	Microsoft Scripting Runtime Object Model	734
	Microsoft Office XP Chart Component Object Model	735
	Microsoft Office XP Data Source Control Object Model	736
	Microsoft Office XP PivotTable Component Object Model	737
	Microsoft Office XP PivotTable Component Object Model (2)	738
	Microsoft Office XP Spreadsheet Component Object Model	739
	Microsoft Office XP Server Extensions Object Model	740
Appendix C	Additional References	741