Author: Richard Mansfield
Publication: Wiley Publication, Sybex.
Contents at a Glance:
Part 1 • RecordingMacros and Getting Started with VBA . . . . . . . . . . . . . . . . 1
Chapter 1 • Recording and Running Macros in the Microsoft Office Applications . . . 3
Chapter 2 • Getting Started with the Visual Basic Editor . . . . . . . . . . . . . . . . . . . . . . 29
Chapter 3 • Editing Recorded Macros . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 61
Chapter 4 • Creating Code from Scratch in the Visual Basic Editor . . . . . . . . . . . . . . 81
Part 2 • Learning How to Work With VBA. . . . . . . . . . . . . . . . . . . . . . . . . . 99
Chapter 5 • Understanding the Essentials of VBA Syntax . . . . . . . . . . . . . . . . . . . . 101
Chapter 6 • Working with Variables, Constants, and Enumerations . . . . . . . . . . . . 115
Chapter 7 • Using Array Variables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 135
Chapter 8 • Finding the Objects, Methods, and Properties You Need . . . . . . . . . . . 155
Part 3 • Making Decisions and Using Loops and Functions . . . . . . . . . . . . . 177
Chapter 9 • Using Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 179
Chapter 10 • Creating Your Own Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 211
Chapter 11 • Making Decisions in Your Code . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 227
Chapter 12 • Using Loops to Repeat Actions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 247
Part 4 • UsingMessage Boxes, Input Boxes, and Dialog Boxes . . . . . . . . . . . 273
Chapter 13 • Getting User Input with Message Boxes and Input Boxes . . . . . . . . . 275
Chapter 14 • Creating Simple Custom Dialog Boxes . . . . . . . . . . . . . . . . . . . . . . . . 295
Chapter 15 • Creating Complex Dialog Boxes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 359
Part 5 • Creating Effective Code . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 405
Chapter 16 • Building Modular Code and Using Classes . . . . . . . . . . . . . . . . . . . . . 407
Chapter 17 • Debugging Your Code and Handling Errors . . . . . . . . . . . . . . . . . . . . 433
Chapter 18 • Building Well-Behaved Code . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 461
Chapter 19 • Securing Your Code with VBA’s Security Features . . . . . . . . . . . . . . . 475
Part 6 • Programming the Office Applications . . . . . . . . . . . . . . . . . . . . . . 495
Chapter 20 • Understanding the Word Object Model and Key Objects . . . . . . . . . . 497
Chapter 21 • Working with Widely Used Objects in Word . . . . . . . . . . . . . . . . . . . 525
Chapter 22 • Understanding the Excel Object Model and Key Objects . . . . . . . . . . 555
Chapter 23 • Working with Widely Used Objects in Excel . . . . . . . . . . . . . . . . . . . . 579
Chapter 24 • Understanding the PowerPoint Object Model and Key Objects . . . . . 593
Chapter 25 • Working with Shapes and Running Slide Shows . . . . . . . . . . . . . . . . 613
Chapter 26 • Understanding the Outlook Object Model and Key Objects . . . . . . . . 633
Chapter 27 • Working with Events in Outlook . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 655
Chapter 28 • Understanding the Access Object Model and Key Objects . . . . . . . . . 671
Chapter 29 • Manipulating the Data in an Access Database via VBA . . . . . . . . . . . 693
Chapter 30 • Accessing One Application from Another Application . . . . . . . . . . . . 713
Chapter 31 • Programming the Office 2007 Ribbon . . . . . . . . . . . . . . . . . . . . . . . . . 739
Appendix • The Bottom Line Solutions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 767
Glossary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 809
Index . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 819
Download Link :
0 Comments:
Post a Comment
Thanks to Ur Support