Microsoft Excel 2000 Power Programming with VBA

John Walkenbach

870 pages, parution le 01/05/1999

Ajouter à une liste

Indisponible

Résumé

With the latest version of Visual Basic for Applications and the new Office Component Object Model, Excel 2000 now provides an amazing platform for the development of custom spreadsheets and turnkey applications for a wide range of business needs. With the expert guidance of John Walkenbach, a leading Excel expert better known as "Mr. Spreadsheet," you'll quickly learn how to harness the full programming power of Excel 2000-from UserForms to class modules.

Preface . . . . . ix
Acknowledgements . . . . . xvii
Part I: Some Essential Background . . . . . 1
Chapter 1: Excel 2000: Where It Came From . . . . . 3
Chapter 2: Excel in a Nutshell . . . . . 15
Chapter 3: Formula Tricks and Techniques . . . . . 35
Chapter 4: Understanding Excel's Files . . . . . 55

Part II: Excel Application Development . . . . . 73
Chapter 5: What Is a Spreadsheet Application' . . . . . 75
Chapter 6: Essentials of Spreadsheet Application Development . . . . . 89

Part III: Understanding Visual Basic for Applications . . . . . 109
Chapter 7: Introducing Visual Basic for Applications . . . . . 111
Chapter 8: VBA Programming Fundamentals . . . . . 165
Chapter 9: Working with VBA Sub Procedures . . . . . 205
Chapter 10: Creating Function Procedures . . . . . 239
Chapter 11: VBA Programming Examples and Techniques . . . . . 271

Part IV: Working with UserForms . . . . . 319
Chapter 12: Introducing UserForms . . . . . 321
Chapter 13: UserForm Examples . . . . . 369
Chapter 14: Advanced UserForm Techniques . . . . . 395

Part V: Advanced Programming Techniques . . . . . 425
Chapter 15: Developing Excel Utilities with VBA . . . . . 427
Chapter 16: Working with Pivot Tables . . . . . 455
Chapter 17: Working with Charts . . . . . 471
Chapter 18: Understanding Excel's Events . . . . . 517
Chapter 19: Interacting with Other Applications . . . . . 547
Chapter 20: Creating and Using Add-Ins . . . . . 565

Part VI: Developing Applications . . . . . 591
Chapter 21: Creating Custom Toolbars 593
Chapter 22: Creating Custom Menus . . . . . 621
Chapter 23: Providing Help for Your Applications . . . . . 655
Chapter 24: Developing User-Oriented Applications . . . . . 677

Part VII: Other Topics . . . . . 691
Chapter 25: Compatibility Issues . . . . . 693
Chapter 26: Reading and Writing Text Files . . . . . 707
Chapter 27: Manipulating Visual Basic Components . . . . . 725
Chapter 28: Understanding Class Modules . . . . . 747
Chapter 29: Frequently Asked Questions about Excel Programming . . . . . 761
Appendix A: Excel Resources Online . . . . . 793
Appendix B: VBA Statements and Functions Reference . . . . . 799
Appendix C: VBA Error Codes . . . . . 809
Appendix D: ANSI Code Reference . . . . . 815
Appendix E: What's on the CD-ROM . . . . . 825
Index . . . . . 841

L'auteur - John Walkenbach

Surnommé Mr. Spreadsheet (Monsieur Tableur), John Walkenbach est un spécialiste reconnu des tableurs, et plus particulièrement d'Excel, Auteur de plus de 30 ouvrages et de 300 articles, il a été récompensé pour son utilitaire Power Utility Pak.