Packed with procedures, tips, tricks, techniques, and ideas, this guide provides comprehensive, coverage of the revamped Excel interface, new file formats, enhanced interactivity with other Office applications, and upgraded collaboration features.
This power-user’s guide is packed with procedures, tips, and ideas for expanding Excel’s capabilities with Visual Basic for Applications. Excel 2007 has a few new tricks up its sleeve, and John Walkenbach helps you make the most of them all. You’ll learn to customize Excel UserForms, develop new utilities, use VBA with charts and PivotTables, and create event-handling applications. Work with VBA subprocedures and function procedures, facilitate interactions with other applications, build user-friendly toolbars, menus, and help systems, and much more. Get ready to make Excel do your bidding.
This book focuses on Visual Basic for Applications (VBA), the programming language built into Excel (and other applications that make up Microsoft Office). More specifically, it will show you how to write programs that automate various tasks in Excel. This book covers everything from recording simple macros through creating sophisticated user-oriented applications and utilities. This book does not cover Microsoft Visual Studio Tools for Office (VSTO). VSTO is a relatively new technology that uses Visual Basic .NET and Microsoft Visual C#. VSTO can also be used to control Excel and other Microsoft Office applications.
You can use this book any way that you please. If you choose to read it from cover to cover, be my guest. But because I’m dealing with intermediate-to-advanced subject matter, the chapter order is often immaterial. I suspect that most readers will skip around, picking up useful tidbits here and there. If you’re faced with a challenging task, you might try the index first to see whether the book specifically addresses your problem.
TABLE OF CONTENT:
Chapter 01 - Excel 2007-Where It Came From
Chapter 02 - Excel in a Nutshell
Chapter 03 - Formula Tricks and Techniques
Chapter 04 - Understanding Excel’s Files
Chapter 05 - What Is a Spreadsheet Application?
Chapter 06 - Essentials of Spreadsheet Application Development
Chapter 07 - Introducing Visual Basic for Applications
Chapter 08 - VBA Programming Fundamentals
Chapter 09 - Working with VBA Sub Procedures
Chapter 10 - Creating Function Procedures
Chapter 11 - VBA Programming Examples and Techniques
Chapter 12 - Custom Dialog Box Alternatives
Chapter 13 - Introducing UserForms
Chapter 14 - UserForm Examples
Chapter 15 - Advanced UserForm 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
Chapter 22 - Working with the Ribbon
Chapter 23 - Working with Shortcut Menus
Chapter 24 - Providing Help for Your Applications
Chapter 25 - Developing User-Oriented Applications
Chapter 26 - Compatibility Issues
Chapter 27 - Manipulating Files with VBA
Chapter 28 - Manipulating Visual Basic Components
Chapter 29 - Understanding Class Modules
Chapter 30 - Working with Colors
Chapter 31 - Frequently Asked Questions about Excel Programming
Appendix A - Excel Resources Online
Appendix B - VBA Statements and Functions Reference
Appendix C - VBA Error Codes
Download from RAPIDSHARE
Download from IFILE
password:knowfree.net