Visual Basic Applications for Office 2000 Unleashed

Paul McFedries is a computer consultant, programmer, and freelance writer. He has worked with computers since 1975 and has a degree in mathematics. He is the author or co-author of more than two dozen computer books that have sold more than one million copies worldwide.

INTRODUCTION Whats New in VBA 6.0 . What You Should Know Before Reading This Book. How This Book Is Organized. About the CD. This Books Special Features. I. UNLEASHING THE VBA PROGRAMMING LANGUAGE. 1. Introducing VBA. What Is a Macro? Recording a VBA Macro. Touring the Visual Basic Editor. Running a VBA Macro. Creating User-Defined Functions with VBA. Working with Procedures. Working with Modules. Setting Visual Basic Editor Options. Protecting Your Code. Summary. 2. Understanding Variables. Declaring Variables. Understanding Variable Scope. Passing Variables as Arguments. Working with Static Variables. Avoiding Variable Errors. Variable Data Types. Using Array Variables. Working with Constants. Summary. 3. Building VBA Expressions. Understanding Expression Structure. VBA Operators. Understanding Operator Precedence. Working with Numeric Expressions. Working with String Expressions. Working with Logical Expressions. Working with Date Expressions. Formatting Numeric and Date Expressions. New VBA 6.0 Functions. Summary. 4. Working with Objects. What Is an Object? The Object Hierarchy. Working with Object Properties. Working with Object Methods. Handling Object Events. Working with Object Collections. The Object Browser. Referencing Additional Object Libraries. Assigning an Object to a Variable. The Is Operator. Working with Multiple Properties or Methods. The Application Object. The Window Object. Summary. 5. Controlling Your VBA Code. Code That Makes Decisions. Using If...Then to Make True/False Decisions. Using If...Then...Else to Handle a False Result. Making Multiple Decisions. Functions That Make Decisions. Code That Loops. Using Do...Loop Structures. Using For...Next Loops. Using For Each...Next Loops. Using Exit For or Exit Do to Exit a Loop. Summary. II. Unleashing Microsoft Office Objects. 6. Word 2000 VBA Programming. The Transition from WordBasic to VBA. Reading and Setting Words Program Options via VBA. Words Application Object. Working with Document Objects. Objects That Represent Text in Word. Checking Spelling and Grammar with VBA. New Objects in Word 2000. Summary. 7. Manipulating Excel 2000 with VBA. Excels Macro Options. Using VBA to Read and Set Excels Program Options. Excels Application Object. Manipulating Workbook Objects. Dealing with Worksheet Objects. Working with Range Objects. Working with Add-In Applications. New Objects in Excel 2000. Summary. 8. Programming Powerpoint 2000 Presentations. PowerPoints Application Object. PowerPoints Presentation Object. Working with PowerPoint Slide Objects. Dealing with Shape Objects. Operating a Slide Show. New Objects in PowerPoint 2000. Summary. 9. VBA and ACCESS 2000. The Access Object Hierarchy. Controlling Access Options. More About the Access Application Object. The Access Form Object. The Access Report Object. The Control Object. Using the Handy SysCmd Function. Creating Access Event Handlers. Working with Access Modules. Protecting Access Projects. New Objects in Access 2000. Summary. III. UNLEASHING VBA USER INTERFACE DESIGN. 10. Interacting with the User. Programming Sounds. Displaying Information to the User. Getting Input from the User. Summary. 11. Working with Microsoft Forms. Understanding Custom Forms and Dialog Boxes. Adding a Form to Your Project. Sharing Forms Between VBA Applications. Changing the Forms Design-Time Properties. Working with Controls. Handling Form Events. Types of Form Controls. Using a Form in a Procedure. Summary. 12. Creating Custom Menu and Toolbars. Assigning Macros to Menu Commands. Creating Custom Toolbars for Your Macros. Menus, Toolbars, and VBA. Understanding Command Bars. Working with Command Bars. Working with Command Bar Controls. Summary. IV. UNLEASHING APPLICATION INTEGRATION. 13. Working with Other Applications. Starting Another Application. Activating a Running Application. Sending Keystrokes to an Application. Using Dynamic Data Exchange. Summary. 14. PROGRAMMING OLE AND ACTIVEX OBJETCS. First, Some OLE Fundamentals. Programming Linked and Embedded Objects. Inserting OLE Objects. Working with Linked and Embedded Objects. Summary. 15. Controlling Applications Via Automation. Understanding Automation. Accessing Automation Objects. Handling Automation Errors. Summary. 16. Rolling Your Own Objects with Class Modules. Partway There: Custom Collections. Understanding Class Modules. Setting Up a Class Module. Implementing Class Properties. Setting Up the Class Methods. Defining the Class Events. Creating Class Collections. Implementing Class Properties for Objects. Using Events with the Office Application Objects. Summary. V. UNLEASHING VBA DATABASE PROGRAMMING. 17. Using VBA to Work with Excel Lists. What Is a List? Working with List Data. Setting Up the Application. Entering Data. Editing Data. Filtering Data. Getting a Count of the Database Records. Deleting Records. Sorting Data. Subtotaling Data. Summary. 18. Programming Data Access Objects. About Data Access Objects. Accessing Data in an External Database. Working with Recordsets. Querying a Recordset. Retrieving Data into Excel. Summary. 19. Advanced Database Programming. Maintaining a Jet Database. Working with Transaction Processing. Using the ODBCDirect Workspace. Programming Jet Database Security. A Peek at the Future: ActiveX Data Objects (ADO). Summary. VI. UNLEASHING VBA INTERNET AND INTRANET " PROGRAMMING. 20. Internet and Intranet Programming Topics. Using VBA to Read and Set the Office 2000 Web Options. Programming Words Email Options. Publishing to HTML. Controlling Office 2000 Hyperlinks. Building a Custom Web Browser. Controlling Internet Explorer Via Automation. Summary. 21. HTML Programming: VBSCRIPT and the SCRIPT EDITOR. The Differences Between VBA and VBScript. Attaching Scripts to a Page. The Scripting Object Hierarchy. How VBScript Interacts with Forms. Example: A Mortgage Calculator. Working with the Script Editor. Summary. 22. Email Programming with Outlook. Understanding the NameSpace Object. Using the Explorer Object. The Inspector Object. Working with MAPIFolder Objects. Understanding Items. A Closer Look at MailItem Objects. Handling Object Events in Outlook VBA. Automation and the Outlook Object Model. Summary. VII. UNLEASHING ADVANCED VBA PROGRAMMING. 23. Trapping Program Errors. A Basic Error-Trapping Strategy. Working with the Err Object. Trappable VBA Errors. Summary. 24. Debugging VBA Procedures. A Basic Strategy for Debugging. Pausing a Procedure. Stepping Through a Procedure. Monitoring Procedure Values. Using the Immediate Window. Debugging Tips. Summary. 25. Programming the Windows API. Understanding the Win32 API. Declaring Win32 API Procedures. Win32 API Examples. The Registry and the Win32 API. Summary. 26. VBA Tips and Techniques. Conditional Compilation in VBA. Saving Application Settings in the Registry. Accessing the File System Through VBA. Low-Level File I/O. Tips for Faster Procedures. Digitally Signing a VBA Project. Summary. VII. UNLEASHING VBA APPLICATIONS 27. An Excel Checkbook Application. Using Checkbook. Balancing the Checkbook. How the Checkbook Application Works. Summary. 28. Making Backups As You Work. Using the Backup Application. Understanding the Backup Application. Backup and the Registry. A Tour of the Backup Form. Backups Support Procedures. Summary. 29. Access and Outlook: Email Merge. What Email Merge Does. Creating a Mailing. A Tour of the Email Merge Database. Under the Hood: The Code. Summary. Appendix A. VBA Statements. Appendix B. VBA Functions. Appendix C. C Programming the Windows Scripting Host. Understanding the Windows Scripting Host. Creating Scripts. The Windows Scripting Host Object Model. The WScript Object. The WshShell Object. The WshNetwork Object. Appendix D. The Windows ANSI Character Set. Appendix E. HTML Primer. Understanding HTML Tags. The Basic Structure of Web Pages. Adding a Title. Text and Paragraphs. Adding Formatting and Headings. Setting Up Lists. Working with Hyperlinks. Inserting Images. Setting Up Tables. Working with HTML Forms. Index.