Curious to learn how to write macros, automate Office applications, or create custom applications in Word, Excel, PowerPoint, Outlook or Access? With this comprehensive guide to Visual Basic for Applications (VBA), you can master the language that underlines the Microsoft Office products.
Revised for the new versions of the language and the Office suite, this book is completely up-to-date. Aimed at everyone from power users to system administrators and professional developers, it covers all Office products in depth. You'll discover that VBA is easily accessible by novice programmers, yet powerful enough for IT professionals who need to create specialized business applications.
Chapter 1 Recording and running macros in the Microsoft
Office applications
Chapter 2 Getting started with the Visual Basic Editor
Chapter 3 Editing recorded macros
Chapter 4 Creating code from scratch in the Visual Basic Editor
Chapter 5 Understanding the essentials of VBA syntax
Chapter 6 Working with variables, constants, and
enumerations
Chapter 7 Using array variables
Chapter 8 Finding the objects, methods, and properties you
need
Chapter 9 Using functions
Chapter 10 Creating your own functions