VBA For Dummies

John Mueller is a freelance author and technical editor. He has writing in his blood, having produced 71 books and over 300 articles to date. The topics range from networking to artificial intelligence and from database management to heads-down programming. Some of his current books include a Windows power optimization book, a book on .NET security, and books on Amazon Web Services, Google Web Services, and eBay Web Services. His technical editing skills have helped more than 50 authors refine the content of their manuscripts. John has provided technical editing services to both Data Based Advisor and Coast Compute magazines. He has also contributed articles to magazines like DevSource, InformIT, Informant, DevX, SQL Server Professional, Visual C++ Developer, Hardcore Visual Basic, asp.netPRO, Software Test & Performance, and Visual Basic Developer.

• Introduction 1Part I: An Overview of VBA 7Chapter 1: Getting to Know VBA 9Chapter 2: Your First VBA Program 33Part II: Learning the Ropes 49Chapter 3: Writing Structured VBA Programs 51Chapter 4: Storing and Modifying Information 79Chapter 5: Creating Structured Programs 111Chapter 6: Trapping Errors and Squashing Bugs 133Chapter 7: Interacting with the User 155Part III: Expanding Your VBA Horizons 179Chapter 8: Object-Oriented Programming 181Chapter 9: Working with Arrays and Collections 205Chapter 10: Working with Disk Files 229Chapter 11: VBA Programming with XML 239Part IV: Programming for Applications 255Chapter 12: VBA Programming in Office 257Chapter 13: VBA Programming in Word 277Chapter 14: VBA Programming in Excel 305Chapter 15: VBA Programming in Access 329Chapter 16: Applications that Work Together 355Part V: The Part of Tens 379Chapter 17: Ten Kinds of VBA Resources 381Chapter 18: Ten Ways to Update Your Old VBA Code Quickly 389On the WebBonus Chapter 1: VBA Programming in FrontPage BC1Bonus Chapter 2: VBA Programming in Visio BC25Bonus Chapter 3: Ten Really Cool Things You Can Do with VBA BC43Index 397