You are previewing Office® XP Development with VBA.
O'Reilly logo
Office® XP Development with VBA

Book Description

  • Create custom business solutions with Microsoft Office XP and Office 2000!

  • Extend Word, Excel, Outlook, and other Office applications.

  • Learn all aspects of Office development, including security and distribution.

  • Leverage Office's powerful collaboration, intranet, and Web capabilities

  • For novice developers and Office power users!

  • Discover the power of Office programming

  • Applies to both Office XP and Office 2000

  • Master the Visual Basic for Applications (VBA) language and development environment

  • Understand the powerful components in the Office object model

  • Build custom tools that leverage email and the Web

  • Construct four Office applications - step-by-step

  • No Microsoft Office programming experience necessary!

  • Developing robust custom solutions with Microsoft Office XP/2000!Microsoft Office is far more than the world's leading office productivity suite. Itspowerful capabilities are organized into hundreds of programmable components, all available to any developer who needs to create custom business solutions. Bycombining these components with the powerful Visual Basic for Applications (VBA) programming language, you can construct powerful applications far more quickly than if you built them from scratch. These components and VBA are available in both Office XP and Office 2000, which means you can use them whether or not you upgraded.

    In this book, expert developer and consultant Peter G. Aitken shows exactly how toleverage the power of Microsoft Office in custom application development. Whetheryou're an experienced developer or a business professional with a problem that needssolving, Aitken will show you how to do it with Office — step by step.

    Aitken begins by reviewing each key Office application - Word, Excel, Access,PowerPoint, Frontpage, and Outlook - and the shared components accessible to all ofthem. You'll discover powerful opportunities for extending and automating Office to increase efficiency and improve collaboration throughout your organization. Then, onestep at a time, Aitken teaches the key VBA skills you'll need to achieve your goals. Finally, this book walks you through the construction of four real-world Office applications, emphasizing the potential value of Office custom solutions in real-world business situations.

    Table of Contents

    1. Copyright
    2. Prentice Hall PTR Microsoft® Technologies Series
    3. Preface
    4. Introduction to Office Development
      1. Why Develop with Office and VBA?
        1. Advantages of Office Development
        2. Software Components
        3. Objects and Components
        4. The Office XP Suite
        5. What's New in Office XP
        6. Summing Up
      2. The Basics of Office Development
        1. Objects and Automation
        2. The Office Object Model
        3. Designing Your Custom Application
        4. A Simple Office Application
        5. Summing Up
      3. Visual Basic for Applications—the Fundamentals
        1. Parts of the VBA Editor
        2. Working with Code
        3. Importing and Exporting Modules
        4. Writing Good Code
        5. Adding References
        6. Securing Your Code
        7. Summing Up
      4. Working with Office Objects
        1. Objects and References
        2. Collections
        3. Finding Objects in the Object Hierarchy
        4. Early versus Late Binding
        5. The Object Browser
        6. Objects and Events
        7. Summing Up
    5. The Office Components
      1. Using Word Components
        1. The Word Object Model
        2. The Document Object
        3. The Selection Object
        4. The Range Object
        5. Using Bookmarks
        6. Finding and Replacing Text
        7. The Application Object
        8. The View Object
        9. Events in Word
        10. Summing Up
      2. Using Excel Components
        1. Excel Overview
        2. The Excel Object Model
        3. The Workbook Object
        4. The Worksheet Object
        5. Range Offsets, Unions, and Intersections
        6. Using the Cells Property
        7. Naming Ranges
        8. Manipulating Worksheet Contents
        9. Working with Charts
        10. The Application Object
        11. Events in Excel
        12. Summing Up
      3. Using Data Access Components
        1. Access Fundamentals
        2. Data Access Technologies
        3. The Access Object Model
        4. Working with Forms and Reports
        5. Working with Data Access Pages
        6. Creating Data Access Pages
        7. Using Data Access Pages
        8. Securing Databases
        9. Database Passwords
        10. Active Data Objects
        11. RecordSets
        12. Summing Up
      4. Using PowerPoint Components
        1. The Presentation Object
        2. The Slide Object
        3. Working With Text on Shapes
        4. The PowerPoint Application Object
        5. Summing Up
      5. Using FrontPage Components
        1. FrontPage Overview
        2. The Web Object
        3. Working with Folders
        4. Working with Web Pages
        5. Working with PageWindows
        6. Dynamic HTML—Should You Use It?
        7. Summing Up
      6. Using Outlook Components
        1. Outlook Overview
        2. The Application and NameSpace Objects
        3. Manipulating Folders and Items
        4. Working with Mail Messages
        5. VBA in Outlook
        6. Events in Outlook
        7. Programming the Calendar
        8. Summing Up
      7. Using the Shared Office Components
        1. Shared Components Overview
        2. The Office Assistant
        3. Displaying Controls in a Balloon
        4. Using Modeless Balloons
        5. The FileDialog Object
        6. The FileSearch Object
        7. Command Bars
        8. Document Properties
        9. Summing Up
    6. The VBA Language
      1. Data Storage and Operators
        1. Basic VBA Syntax
        2. Storing Program Data
        3. Arrays
        4. Static Arrays
        5. Dynamic Arrays
        6. Operators
        7. Summing Up
      2. Conditional and Loop Statements
        1. Conditional Statements
        2. Loop Statements
        3. The GoTo Statement
        4. Summing Up
      3. Writing Procedures
        1. Types of Procedures
        2. Defining a Procedure
        3. Passing Arguments
        4. Variables in Procedures
        5. Calling a Procedure
        6. Named Arguments
        7. Procedure Scope
        8. Planning and Storing Procedures
        9. Summing Up
      4. Working with Strings
        1. String-Processing Summary
        2. Summing Up
      5. Working with Dates and Times
        1. The Date Data Type
        2. Creating Dates and Times
        3. Adding and Subtracting Dates and Times
        4. Getting Date and Time Information
        5. Formatting Dates and Times
        6. Summing Up
      6. Working with Files
        1. Overview
        2. File Access
        3. Working with Text Files
        4. File Management
        5. FSO Methods
        6. The Drive Object
        7. The Folder Object
        8. The File Object
        9. Summing Up
      7. Creating Custom Classes and Objects
        1. Why Create Classes?
        2. Class Module Fundamentals
        3. Creating Class Properties
        4. Creating Class Methods
        5. Class Events
        6. A Class Demonstration
        7. Summing Up
      8. Creating User Forms
        1. Creating a User Form
        2. What Controls Are Available?
        3. User Form Code and Event Procedures
        4. Displaying, Using, and Hiding User Forms
        5. A User Form Demonstration
        6. Summing Up
    7. Other Office Development Tools
      1. VBA Error Handling
        1. Writing Solid Code
        2. Runtime Errors
        3. The Err Object
        4. Handling an Error
        5. Resuming Execution After an Error
        6. On Error Resume Next
        7. ADO Errors
        8. Raising Errors
        9. Class Module Errors
        10. Returning Errors from Functions
        11. Testing Your Error-Handling Code
        12. Error Logging
        13. Dealing with Unanticipated Errors
        14. Summing Up
      2. Debugging, Deploying, and Supporting Your Application
        1. Debugging Your Applications
        2. Working with Breakpoints
        3. Using Watches
        4. The Locals Window
        5. Controlling Program Execution
        6. Deploying Your Application
        7. Supporting an Application with Online Help
        8. Summing Up
      3. Using the Windows API and Registry
        1. The Windows API
        2. Strings and API Procedures
        3. Using Callbacks
        4. The Windows Registry
        5. Summing Up
      4. Office Technologies for the Web
        1. Web Components Overview
        2. Using the Web Components
        3. Using the Spreadsheet Control
        4. Using the PivotTable Control
        5. Using the Chart Control
        6. Using the DataSource Control
        7. Summing Up
    8. Putting It All To Work
      1. Web Publishing of a Multiauthor Compound Document
        1. The Scenario
        2. Planning
        3. The Main Application
        4. Summing Up
      2. Numeric Processing and Graphing
        1. The Scenario
        2. Planning
        3. Creating the Workbook
        4. Planning the Code
        5. Potential Errors and Bugs
        6. The Main Procedure
        7. The Secondary Procedures
        8. Summing Up
      3. Custom Report Generation
        1. The Scenario
        2. Report Generation Basics
        3. Structure of a Report
        4. Adding Report Elements
        5. A Demonstration
        6. Summing Up
      4. KeyCode Constants and Values
        1. Keys on the Numeric Keypad
        2. Function Keys