Mastering Vba For Microsoft Office 2007

0.0

Mastering VBA for Microsoft Office 2007 covers the basics of the language in clear, systematic tutorials, and includes intermediate and advanced content for experienced VB developers. Unlike the competition, which addresses just one Office application, this book covers the whole Office suite. Further, all of the content is anchored with solid,real-world projects in Word, Excel, Outlook, Power Point, and Access. About The Author Richard Mansfield is the author of 41 computer books, including How to Do Everything with Second Life (McGraw-Hill), CSS Web Design for Dummies (Wiley), Office 2003 Application Development All-in-One Desk Reference For Dummies (Wiley), The Visual Basic .NET Power Toolkit (Sybex), The Savvy Guide to Digital Music (Sams), and Hacker Attack (Sybex). He is the former editor of COMPUTE! Magazine and has written hundreds of magazine articles and two columns. From 1987 to 1991, Richard was editorial director and partner in Signal Research, and began writing books full-time in 1991. His books have have been translated into 12 languages. Table Of Contents Part 1: Recording Macros and Getting Started with VBA Recording and Running Macros in the Office Applications Getting Started with the Visual Basic Editor Editing Recorded Macros Creating Code from Scratch in the Visual Basic Editor Part 2: Learning How to Work with VBA Understanding the Essentials of VBA Syntax Working with Variables, Constants, and Enumerations Using Array Variables Finding the Objects, Methods, and Properties You Need Part 3: Making Decisions and Using Loops and Functions. Using Functions Creating Your Own Functions Making Decisions in Your Code Using Loops to Repeat Actions Part 4: Using Message Boxes, Input Boxes, and Dialog Boxes Getting User Input with Message Boxes and Input Boxes Creating Simple Custom Dialog Boxes Creating Complex Dialog Boxes Part 5: Creating Effective Code Building Modular Code and Using Classes Debugging Your Code and Handling Errors Building Well-Behaved Code Securing Your Code with VBA's Security Features Part 6: Programming the Office Applications Understanding the Word Object Model and Key Objects Working with Widely Used Objects in Word Understanding the Excel Object Model and Key Objects Working with Widely Used Objects in Excel Understanding the Power Point Object Model and Key Objects Working with Shapes and Running Slide Shows Understanding the Outlook Object Model and Key Objects Working with Events in Outlook Understanding the Access Object Model and Key Objects Manipulating the Data in an Access Database via VBA Accessing One Application from another Application Glossary