Skip to main content

VBA For Dummies, 4th Edition

VBA For Dummies, 4th Edition

John Paul Mueller

ISBN: 978-0-764-53989-3

Oct 2003

408 pages

Select type: Paperback

Product not available for purchase

Description

* Gives programmers, software developers, and advanced users of Microsoft Office applications all the key concepts necessary to write VBA programs for the new Office ""X""
* Fully updated to cover all the changes in the newest release of Office
* VBA (Visual Basic for Applications) is the primary development tool for all applications in the Microsoft Office suite-Access, Excel, and Word-and according to Microsoft, more than 2.6 million programmers currently use VBA
* Since VBA is also licensed to other software developers and vendors, it is built into some non-Microsoft, third-party software; programs that include VBA can be tailored to fit specific business needs
* Shows programmers how to build applications with VBA and covers all the essentials, including: VBA visual programming tools, recording and modifying macros, basic VBA programming, running VBA programs, using the VBA Editor, debugging and error trapping, plus more advanced topics, such as built-in VBA commands and working with objects
* Author has written and/or cowritten more than fifty-eight technology books
Introduction.

Part I: An Overview of VBA.

Chapter 1: Getting to Know VBA. Chapter 2: Your First VBA Program.

Part II: Learning the Ropes.

Chapter 3: Writing Structured VBA Programs.

Chapter 4: Storing and Modifying Information.

Chapter 5: Creating Structured Programs.

Chapter 6: Trapping Errors and Squashing Bugs.

Chapter 7: Interacting with the User.

Part III: Expanding Your VBA Horizons.

Chapter 8: Object-Oriented Programming.

Chapter 9: Working with Arrays and Collections.

Chapter 10: Working with Disk Files.

Chapter 11: VBA Programming with XML.

Part IV: Programming for Applications.

Chapter 12: VBA Programming in Office.

Chapter 13: VBA Programming in Word.

Chapter 14: VBA Programming in Excel.

Chapter 15: VBA Programming in Access.

Chapter 16: Applications that Work Together.

Part V: The Part of Tens.

Chapter 17: Ten Really Cool Things You Can Do with VBA.

Chapter 18: Ten Kinds of VBA Resources.

Index.

Source Code Download