Details
Author: Walkenbach, John
ISBN: 0764530011
Publisher: IDG Books Worldwide, 1996
Includes: CD-ROM
Status: Available
Comments: This is a revised edition of my original book is intended for experienced Excel users who want to learn to develop applications using Excel. More than just a VBA book, it also covers spreadsheet application development from a broader perspective. It covers advanced topics, and includes many tips and examples that cannot be found elsewhere. Every chapter has been updated, and I added two new chapters (13 and 20).
Table of Contents
Introduction
Part I: Some Essential Background
- Chapter 1: Excel 95: Where It Came From
- Chapter 2: Excel in a Nutshell
- Chapter 3: Understanding Excel's Files
Part II: Excel Application Development
- Chapter 4: What is a Spreadsheet Application?
- Chapter 5: Essentials of Spreadsheet Application Development
Part III:Understanding Visual Basic for Applications
- Chapter 6: Introducing Visual Basic for Applications
- Chapter 7: VBA Programming Fundamentals
- Chapter 8: Working with VBA Subroutine Procedures
- Chapter 9: Creating Function Procedures
- Chapter 10: Creating Custom Dialog Boxes
- Chapter 11: VBA Programming Examples and Techniques
- Chapter 12: Developing Excel Utilities with VBA
- Chapter 13: Using the Data Access Object
- Chapter 14: Creating and Using Add-Ins
Part IV: Putting It All Together
- Chapter 15: Creating Custom Menus
- Chapter 16: Creating Custom Toolbars
- Chapter 17: Providing Help for Your Applications
- Chapter 18: Interacting with Other Applications
- Chapter 19: Developing User-Oriented Applications
- Chapter 20: Compatibility Issues
- Chapter 21: Other Resources
- Chapter 22: Frequently Asked Questions About Excel and VBA
Part V: Appendixes
- Appendix A: Excel and VBA Constants Reference
- Appendix B: VBA Statements and Functions Reference
- Appendix C: VBA Error Code Reference
- Appendix D: ANSI Code Reference