- STAFF PICKS
- GIFTS + GIFT CARDS
- SELL BOOKS
- FIND A STORE
New Trade Paper
Currently out of stock.
Microsoft Excel 2000 Power Programming with VBA with CDROMby John Walkenbach
Synopses & Reviews
Microsoft® Excel 2000 Power Programming with VBA 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. Take Your Spreadsheets to a Whole New Level
A guide to using MS Excel 2000, and VBA programming techniques, which includes a CD-ROM with an assortment of Excel shareware.
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.
M&T Books publishes top-quality references and guides for information technology professionals. Written for intermediate to advanced programmers, developers, Web designers, and network administrators, the series under the M&T Books imprint include:
About the Author
About the Author John Walkenbach is a principal of JWalk and Associates Inc., a Southern California-based consulting firm specializing in spreadsheet application development. The top-selling author of two dozen spreadsheet books, he is also the "Spreadsheet Tips" columnist for PC World. He developed the Power Utility Pak, an award-winning utility package for Excel, and maintains the Spreadsheet Page, a popular Internet Web site.
Table of Contents
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: Understanding Excel's 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: Reading and Writing Text Files.
Chapter 27: Manipulating Visual Basic Components.
Chapter 28: Understanding Class Modules.
Chapter 29: Frequently Asked Questions about Excel Programming.
Appendix A: Excel Resources Online.
Appendix B: VBA Statements and Functions Reference.
Appendix C: VBA Error Codes.
Appendix D: ANSI Code Reference.
Appendix E: What's on the CD-ROM.
End-User License Agreement.
CD-ROM Installation Instructions.
What Our Readers Are Saying
Other books you might like
Computers and Internet » Computer Languages » Visual Basic