Excel 2000 Power Programming With VBA

John's Excel books

Order this book from amazon.com

Details

Author: Walkenbach, John

ISBN: 0-7645-3263-4

Publisher: IDG Books Worldwide, 1999, 869 pp., List price $49.95 (US)

Includes: CD-ROM

Status: Available

Target Reader: This book is intended for experienced Excel users who want to master VBA.

Comments: All humility aside, this is my best book ever -- the ultimate VBA book for Excel 97 and Excel 2000. Previous editions of this book have received rave reviews, but this one is easily twice as good as the previous edition.

Unlike other VBA books, it also covers spreadsheet application development from a broader perspective. It covers many advanced topics, and includes tons of insider tips and useful examples that cannot be found elsewhere.

NOTE: This book contains a coupon for a free copy of Power Utility Pak 2000. Unfortunately, the first 3,000 copies of this book were printed without a Power Utility Pak 2000 coupon. If you have one of these "sure-to-be-collectible" editions, click here to print a coupon.

Preface

Part I: Some Essential Background

Chapter 1: Excel 2000: Where It Came From
Chapter 2: Excel in a Nutshell
Chapter 3: Formula Tricks and Techniques
Chapter 4: Understanding Excel’s Files

Part II: Excel Application Development

Chapter 5: What Is a Spreadsheet Application?
Chapter 6: Essentials of Spreadsheet Application Development

Part III: Understanding Visual Basic for Applications

Chapter 7: Introducing Visual Basic for Applications
Chapter 8: VBA Programming Fundamentals
Chapter 9: Working with VBA Sub Procedures
Chapter 10: Creating Function Procedures
Chapter 11: VBA Programming Examples and Techniques

Part IV: Working With UserForms

Chapter 12: Introducing UserForms
Chapter 13: UserForm Examples
Chapter 14: Advanced UserForm Techniques

Part V: Advanced Programming Techniques

Chapter 15: Developing Excel Utilities with VBA
Chapter 16: Working With Pivot Tables
Chapter 17: Working With Charts
Chapter 18: Working With Events
Chapter 19: Interacting with Other Applications
Chapter 20: Creating and Using Add-Ins

Part VI: Developing Applications

Chapter 21: Creating Custom Toolbars
Chapter 22: Creating Custom Menus
Chapter 23: Providing Help for Your Applications
Chapter 24: Developing User-Oriented Applications

Part VII: Other Topics

Chapter 25: Compatibility Issues
Chapter 26: Manipulating Files With VBA
Chapter 27: Manipulating Visual Basic Components
Chapter 28: Understanding Class Modules
Chapter 29: Frequently Asked Questions about Excel Programming

Part V: Appendixes

Appendix A: Excel Resources Online
Appendix B: VBA Keywords Reference
Appendix C: VBA Error Codes
Appendix D: ANSI Code Reference
Appendix E: What's On the CD-ROM