Excel 2002 Power Programming with VBA - John Walkenbach

Excel 2002 Power Programming with VBA

(Autor)

Buch | Softcover
984 Seiten
2001
Hungry Minds Inc,U.S. (Verlag)
978-0-7645-4799-7 (ISBN)
46,55 inkl. MwSt
  • Titel ist leider vergriffen;
    keine Neuauflage
  • Artikel merken
Master the programming features in Excel 2002 and unleash the power of VBA (VIsual Basic for Applications). With the author's expert guideance, you should quickly lean how to harness the full programming power of Excel 2002 - from UserForms to class modules.
Get the most out of Excel, Microsoft's powerful spreadsheet application. With John Walkenbach, the leading Excel expert better known as "Mr. Spreadsheet", discover better ways to analyze data and find solutions using Microsoft Excel 2002. 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.

John Walkenbach is a principal of JWalk and Associates, Inc., a consulting firm that specializes in spreadsheet application development, and is the author of more than two dozen books, including, most recently, Excel 2002 Bible and Excel 2002 Formulas. He maintains "The Spreadsheet Page," a popular Web resource at www.j-walk.com/ss.

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.

Erscheint lt. Verlag 15.7.2001
Zusatzinfo illustrations
Verlagsort Foster City
Sprache englisch
Maße 189 x 233 mm
Gewicht 1389 g
Einbandart Paperback
Themenwelt Informatik Betriebssysteme / Server Windows
Informatik Office Programme Excel
Mathematik / Informatik Informatik Programmiersprachen / -werkzeuge
ISBN-10 0-7645-4799-2 / 0764547992
ISBN-13 978-0-7645-4799-7 / 9780764547997
Zustand Neuware
Haben Sie eine Frage zum Produkt?
Mehr entdecken
aus dem Bereich
Insider-Wissen – praxisnah & kompetent

von Ed Bott

Buch | Hardcover (2023)
dpunkt (Verlag)
44,90
Daten abfragen und verarbeiten mit Excel und Power BI

von Ignaz A. Schels

Buch (2023)
Hanser (Verlag)
49,99