Microsoft Office programming - A guide for experienced developers

• Starts where other VBA tutorials end
• Covers the material not shared by all of the Office applications
• Shows how to use multiple Office applications together to build integrated solutions
• For experienced, serious coders

By using the same back-end macro programming language, Visual Basic for Applications (VBA), Microsoft Office applications allow users to easily transfer their VBA programming skills from one Office product to another. A developer who is skilled at using VBA to program Access can quickly learn to program Word or Excel. Better still, VBA is a fairly complete subset of Visual Basic (VB). That means a Visual Basic developer already knows how to use VBA and a VBA programmer knows a lot about Visual Basic.

In addition to this large body of shared information, learning to program Office applications requires that the developer understand each application's specific features. For example, to write VBA code for Microsoft Word, the developer must understand Word's capabilities and how to make Word do useful things.

Currently, if you want to learn how to program several Office applications, you must buy separate books for each application with a huge amount of overlap. Even worse, these books will assume you have absolutely no experience with programming.

Microsoft Office Programming: A Guide for Experienced Developers explains how to link the applications together using OLE, how to manipulate each application with VBA code, and how to make the applications work together by controlling each other.

Contents

• Introduction
• Macros
• Customizing Office
• Automatic Customization
• Office Programming the Easy Way: OLE
• Introduction to Office XP Object Models
• Word
• Excel
• PowerPoint
• Access
• Access and ADO
• Outlook
• Outlook, MAPI, and CDO
• Smart Tags
• Office 2003
• Index