VBA for dummies

VBA helps you put your computer in its place. Write programs that automate tasks and make Office 2007 work better for you. If your computer is becoming your boss instead of your servant, start using VBA to tell it what to do! Here's the latest on the VBA IDE and program containers, debugging and controlling your programs, working with multiple applications using a single program, and the most exciting stuff -- programming for all the Office 2007 applications. & nbsp;Read more... VBA For Dummies, 5th Edition; About the Author; Dedication; Author's Acknowledgments; Contents at a Glance; Table of Contents; Introduction; Part I: An Overview of VBA; Part II: Learning the Ropes; Part III: Expanding Your VBA Horizons; Part IV: Programming for Applications; Part V: The Part of Tens; Index; Bonus Chapter 1: VBA Programming in FrontPage; Bonus Chapter 2: VBA Programming in Visio; Bonus Chapter 3: Ten Really Cool Things You Can Do with VBA VBA For Dummies, 5th Edition 3 About the Author 5 Dedication 7 Author’s Acknowledgments 7 Contents at a Glance 9 Table of Contents 11 Introduction 19 About This Book 19 Conventions Used in This Book 20 What You Should Read 20 What You Don’t Have to Read 21 Foolish Assumptions 21 How This Book Is Organized 21 Icons Used in This Book 24 Where to Go from Here 24 Part I: An Overview of VBA 25 Chapter 1: Getting to Know VBA 27 Batteries Included — VBA Comes with Office 28 VBA: It’s Not Just for Programmers 30 Other Products Use VBA, Too 33 A Room with a View 33 Starting the Visual Basic Editor 36 Chapter 2: Your First VBA Program 51 Deciding What to Do 52 Steps to Create a VBA Program 53 Four Ways to Run Your Program 58 Using Help to Your Advantage — Stealing Microsoft’s Code 65 Part II: Learning the Ropes 67 Chapter 3: Writing Structured VBA Programs 69 Parts of a Program 70 Taking the Lego Approach 84 Writing Your First Sub 89 Writing Your First Function 91 Getting the Scoop on Scope 93 Creating Readable Code 95 Telling Others about Your Code 95 Chapter 4: Storing and Modifying Information 97 Understanding Variables and Constants 98 Defining the Data Types 101 Working with Operators 124 Applying What You Know to Design an Excel Report 125 Chapter 5: Creating Structured Programs 129 Exercising Control with Structures 129 Making a Decision with the If... Then Statement 130 Making a Choice by Using the Select Case Statement 138 Performing a Task More than Once by Using Loops 142 Redirecting the Flow by Using GoTo 148 Chapter 6: Trapping Errors and Squashing Bugs 151 Knowing the Enemy 152 Prevention Is Better than a Cure 156 Saving and Restoring Code 165 Time for a Bug Hunt 166 Using the Locals Window 169 Using the Watches Window 170 Chapter 7: Interacting with the User 173 Understanding Forms 173 Using the Basic Controls 176 Using the Forms You Create 191 Part III: Expanding Your VBA Horizons 197 Chapter 8: Object-Oriented Programming 199 Understanding Classes 199 Designing a Basic Class 203 Using Your New Object in an Application 216 Adding Error Handling to Classes 218 Using the With Statement 220 Adding a Digital Signature to Your Creation 221 Chapter 9: Working with Arrays and Collections 223 Using Arrays for Structured Storage 224 Using Collections to Create Data Sets 231 Defining Your Own Data Types 239 Chapter 10: Working with Disk Files 247 Using Disk Storage 248 Working with Settings 250 Chapter 11: VBA Programming with XML 257 Comparing WordML with Saved XML 258 Manipulating XML Data 261 Creating a Simple Word XML Document 265 Changing the Face of XML with XSLT 267 Part IV: Programming for Applications 273 Chapter 12: VBA Programming in Office 275 Working with the User Environment 275 Manipulating Toolbars and Menus 278 Working with the New Ribbon Interface 284 Chapter 13: VBA Programming in Word 295 Understanding the Word-Related Objects 296 Accessing the Word Document 304 Using the Registry with VBA 307 Selecting Objects in a Word Document 309 Manipulating Text 313 Working with Envelopes and Labels 317 Chapter 14: VBA Programming in Excel 323 Understanding the Excel-Related Objects 324 Selecting Objects within Excel 339 Developing Custom Functions in Excel 342 Chapter 15: VBA Programming in Access 347 Understanding the Access-Related Objects 349 Understanding SQL: A Quick Overview 365 Adding Form-Related Applications 369 Creating Automatic Applications 372 Chapter 16: Applications that Work Together 373 Understanding Why You Should Work with More than One Application 374 Starting and Stopping External Applications 375 Processing Outlook E-Mail Messages with Word 383 Sending E-Mail Messages with Outlook 386 Sending Notes from Word to Excel 392 Part V: The Part of Tens 397 Chapter 17: Ten Kinds of VBA Resources 399 Using Magazines and Periodicals 400 Using RSS to Obtain the Latest Information 401 Finding Interesting Newsgroups and List Servers 402 Locating Just the Right Code 404 Getting Tools to Make Programming Easier 405 Downloading ActiveX Controls and Third-Party Components 406 Using the Author As a Resource 406 Chapter 18: Ten Ways to Update Your Old VBA Code Quickly 407 Debugging Your Code Before Making Changes 408 Using Search-and-Replace to Your Advantage 408 Asking Others About a Fix 409 Maintaining a Log 411 Grabbing Helpful Code from VBA Help 412 Getting Your Users to Help You 412 Creating an Update Plan 413 Learning When That Old Code Won’t Update 413 Using the Code in This Book for Updates 414 Index 415 Bonus Chapter 1: VBA Programming in FrontPage 435 Using FrontPage with VBA 435 Understanding the FrontPage-Related Objects 436 Working with FrontPage Documents 450 Bonus Chapter 2: VBA Programming in Visio 459 Using Visio with VBA 460 Understanding the Visio-Related Objects 460 Bonus Chapter 3: Ten Really Cool Things You Can Do with VBA 477 Personalizing Your VBA Applications 477 Using Files with the Open Command 478 Defining Database Connections 480 Automating PowerPoint Presentations 482 Creating Data Connections with OLE 482 Adding Functionality with Controls 483 Getting and Using Components 484 Using Microsoft’s Online Documentation 485 Creating Your Own Jigs and Templates 485 Developing Reusable Libraries 486

VBA helps you put your computer in its place

Write programs that automate tasks and make Office 2007 work better for you

If your computer is becoming your boss instead of your servant, start using VBA to tell it what to do! Here's the latest on the VBA IDE and program containers, debugging and controlling your programs, working with multiple applications using a single program, and the most exciting stuff — programming for all the Office 2007 applications.

Discover how to

• Customize an application's interface
• Quick-launch a VBA program
• Store and modify information
• Use VBA with the Ribbon
• Understand object-oriented programming
• Avoid runtime errors

VBA helps you put your computer in its place

Write programs that automate tasks and make Office 2007 work better for you

If your computer is becoming your boss instead of your servant, start using VBA to tell it what to do! Here's the latest on the VBA IDE and program containers, debugging and controlling your programs, working with multiple applications using a single program, and the most exciting stuff -- programming for all the Office 2007 applications.

Discover how to

• Customize an application's interface
• Quick-launch a VBA program
• Store and modify information
• Use VBA with the Ribbon
• Understand object-oriented programming
• Avoid runtime errors