Ships from: fallbrook, CA
Usually ships in 1-2 business days
Ships from: Murphy, TX
Usually ships in 1-2 business days
This book is an excellent resource for getting up to speed using streamlined spreadsheet creation tools, enhanced analysis tools and powerful Web integration. Transform Excel into an application suited to the whole organization so workgroups can work more effectively. Discover how developers can integrate information seamlessly, whether proposal text, financial figures or research data. Whether you are an expert or a novice, Excel 2002 Power Programming with VBA will help you work more efficiently, turning your data into answers you can count on.
Bonus: The book contains a coupon for the Professional Power Utility Pak.
Preface.
Acknowledgments.
PART I: Some Essential Background.
Chapter 1: Excel 2002: 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: Custom Dialog Box Alternatives.
Chapter 13: Introducing UserForms.
Chapter 14: UserForm Examples.
Chapter 15: Advanced UserForm Techniques.
PART V: Advanced Programming Techniques.
Chapter 16: Developing Excel Utilities with VBA.
Chapter 17: Working with Pivot Tables.
Chapter 18: Working with Charts.
Chapter 19: Understanding Excel's Events.
Chapter 20: Interacting with Other Applications.
Chapter 21: Creating and Using Add-Ins.
PART VI: Developing Applications.
Chapter 22: Creating Custom Toolbars.
Chapter 23: Creating Custom Menus.
Chapter 24: Providing Help for Your Applications.
Chapter 25: Developing User-Oriented Applications.
PART VII: Other Topics.
Chapter 26: Compatibility Issues.
Chapter 27: Manipulating Files with VBA.
Chapter 28: Manipulating Visual Basic Components.
Chapter 29: Understanding Class Modules.
Chapter 30: 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.
Index.
End-User License Agreement.
CD-ROM Installation Instructions.
Anonymous
Posted Mon Jun 02 00:00:00 EDT 2003
This book contains a lot of detail on a lot of examples, but try to find something you need! The order of events is 'stream of conciousness', that is, every topic is in the order that it happened to occur to the author - regardless of its relevance to the topic at hand. Read some other titles to see what organization means.
Was this review helpful? Yes NoThank you for your feedback. Report this reviewThank you, this review has been flagged.Anonymous
Posted Thu May 29 00:00:00 EDT 2003
This book has some interesting stuff in it, but absolutely no organization. It's like looking for a needle in a haystack. If you have the same 'stream of conciousness' as John. you might figure out why no topic is treated in one place, but rather, every topic is a bit here a bit there - just when John happened to think of it. There are better and newer books to look at.
Was this review helpful? Yes NoThank you for your feedback. Report this reviewThank you, this review has been flagged.Anonymous
Posted Tue Jul 16 00:00:00 EDT 2002
I bought this book so I can learn more about programming excel through VB Apps. It covers just about everything you need to know. It goes into many advanced features. As an intermediate programmer I find this book very useful and full of examples. If you want to know more about the excel syntax...this is a book for you!
Was this review helpful? Yes NoThank you for your feedback. Report this reviewThank you, this review has been flagged.
Overview
This book is an excellent resource for getting up to speed using streamlined spreadsheet creation tools, enhanced analysis tools and powerful Web integration. Transform Excel into an application suited to the whole organization so workgroups ...