Sams Teach Yourself Visual Basic for Applications 5 in 21 Days

• Master VBA programming in Microsoft Office 97 applications
• Learn how to write and debug VBA programs
• Find out how to speed up the programming process with VBA's Object Browser
• Discover how to use VBA to control several different applications from the same macro program
• Add new functions and capabilities to your Excel, Word, and other VBA host applications
• Explore built-in functions, arrays, subroutines, error handling, user-defined functions, string operators and expressions, variables, and constants -- in detail
• Get expert tips and advice on creating macros, editing and enhancing recorded macros, and writing complete add-in applications
• Simplify and streamline routine or complex tasks using VBA macro programs

Table of contents

Chapter 1. Getting Started

Chapter 2. Writing and Editing Simple Macros

Chapter 3. Understanding Data Types, Variables, and Constants

Chapter 4. Operators and Expressions

Chapter 5. Using Visual Basic and Host Application Functions

Chapter 6. Creating and Using Function Procedures and User-Defined Functions

Chapter 7. Understanding Objects and Collections

Chapter 8. Making Decisions in Visual Basic for Applications

Chapter 9. Repeating Actions in Visual Basic: Loops

Chapter 10. Data Types and Variables: Advanced Topics

Chapter 11. Creating Libraries and Whole Programs: Modular Programming Techniques

Chapter 12. Managing Files with Visual Basic for Applications

Chapter 13. Arrays

Chapter 14. Debugging and Testing VBA Code

Chapter 15. Creating Custom Dialog Boxes

Chapter 16. Menus and Toolbars

Chapter 17. Error Handling

Chapter 18. Controlling the VBA Host Applications

Chapter 19. Working with Other Applications: OLE and Automation

Chapter 20. Working with Other Applications: DDE, DLLs, and Sending Keystrokes

Chapter 21. Using Event Procedures and Add-Ins

Appendix A: Answers

Index