Visual Basic for applications unleashed

Paul McFedries
Cover......Page 1
Overview......Page 3
Overview (continued)......Page 4
Acknowledgments......Page 23
About the Author......Page 24
Tell Us What You Think!......Page 25
Introduction......Page 26
How This Book Is Organized......Page 30
Online Resources for This Book......Page 32
This Book’s Special Features......Page 33
Part I Unleashing the VBA Programming Language......Page 35
Ch 1  Introducing VBA......Page 37
Ch 2 Understanding Variables......Page 73
Ch 3 Building VBA Expressions......Page 93
Ch 4 Working with Objects......Page 127
Ch 5 Controlling Your VBA Code......Page 149
Part II Unleashing Microsoft Office Objects......Page 170
Ch 6 Word for Windows VBA Programming......Page 172
Ch 7  Manipulating Excel with VBA......Page 203
Ch 8 Programming PowerPoint Presentations......Page 248
Ch 9 VBA and Access......Page 277
Part III Unleashing VBA User Interface Design......Page 304
Ch 10 Interacting with the User......Page 305
Ch 11 Working with Microsoft Forms......Page 322
Ch 12  Creating Custom Menus and Toolbars......Page 360
Part IV Unleashing Application Integration......Page 384
Ch 13 Working Other Applications......Page 385
Ch 14 Programming OLE and ActiveX Objects......Page 406
Ch 15 Controlling Applications Via OLE Automation......Page 434
Ch 16 Rolling Your Objects with Class Modules......Page 447
Part V Unleashing VBA Database Programming......Page 466
Ch 17 Using VBA to Work with Excel Lists......Page 467
Ch 18 Programming Data Access Objects......Page 491
Ch 19 Advanced Database Programming......Page 514
Part VI Unleashing VBA Internet and Intranet Programming......Page 554
Ch 20 Internet and Intranet Programming Topics......Page 555
Ch 21 Web Page Programming:ActiveX and VBScript......Page 586
Ch 22 E-Mail and Groupware Programming with Outlook......Page 622
Part VII Unleashing Advanced VBA Programming......Page 669
Ch 23 Trapping Program Errors......Page 670
Ch 24 Debugging VBA Procedures......Page 686
Ch 25 Programming the Windows API......Page 705
Ch 26 VBA Tips and Techniques......Page 742
Part VIII Unleashing VBA Applications......Page 781
Ch 27 A Check Book Application......Page 782
Ch 28 Making Backups as You Work......Page 812
Ch 29 Access and Outlook:E-Mail Merge......Page 846
Appendix A VBA Statements......Page 877
Appendix B VBA Functions......Page 885
Appendix C The Windows ANSI Character Set......Page 895
Appendix D An HTML Primer......Page 903