Excel 2002 Power Programming with VBA
(Sprache: Englisch)
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...
This book is an...
Leider schon ausverkauft
versandkostenfrei
Buch
57.90 €
Produktdetails
Produktinformationen zu „Excel 2002 Power Programming with VBA “
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.
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.
Klappentext zu „Excel 2002 Power Programming with VBA “
Excel 2002 Power Programming with VBA Develop Powerful, User-Oriented Excel 2002 Applications. With this unique guide, renowned spreadsheet authority John Walkenbach invites you to harness the full potential of Excel-and join the elite group of users and developers who truly understand what the product is capable of. Offering plenty of detailed, well-thought-out examples, he walks you through the basics of Excel application development and VBA programming-and then gives you a lucid, wide-ranging seminar on advanced programming techniques and application development issues. It's all you need to create user-oriented custom applications that leverage the power of Excel 2002. Your Road Map to Excel Application Development- Take Excel to the next level with formula tricks and techniques
- Work with VBA sub procedures and function procedures
- Create stellar UserForms as well as custom dialog box alternatives
- Develop applications that maximize the power of PivotTables and charts
- Incorporate event-handling and interactions with other applications
- Build user-friendly toolbars, menus, and help systems
- Manipulate files and Visual Basic components and understand class modules
- Get advice on compatibility issues and answers to frequently asked Excel programming questions
Bonus CD-ROM Includes
-A trial version of the author's award-winning Power Utility Pak 2000
- A demo of the author's Sound-Proof 2000
- Over 175 example Excel workbooks from the book
System Requirements: Pentium PC with Windows 98 or greater; 32 MB RAM; Microsoft Excel 2002.
Inhaltsverzeichnis zu „Excel 2002 Power Programming with VBA “
PrefaceAcknowledgments
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
Bibliographische Angaben
- Autor: John Walkenbach
- 2001, XXXVIII, 934 Seiten, Maße: 23,5 cm, Kartoniert (TB), Englisch
- Verlag: Wiley & Sons
- ISBN-10: 0764547992
- ISBN-13: 9780764547997
Sprache:
Englisch
Kommentar zu "Excel 2002 Power Programming with VBA"
0 Gebrauchte Artikel zu „Excel 2002 Power Programming with VBA“
Zustand | Preis | Porto | Zahlung | Verkäufer | Rating |
---|
Schreiben Sie einen Kommentar zu "Excel 2002 Power Programming with VBA".
Kommentar verfassen