 |
Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel and VBA
Customer Reviews: 1 Average Customer Rating:  Write a Review and tell the world about this title! People who purchase this book frequently purchase: - Microsoft Office Excel 2003 Power Programming with VBA; John Walkenbach, $31.50, 37% Off!
- Excel 2003 VBA Programmer's Reference; John Green, et al, $25.50, 36% Off!
- VBA and Macros for Microsoft Excel; Bill Jelen, et al, $25.50, 36% Off!
- Microsoft Office Excel 2003 Formulas; John Walkenbach, $27.95, 38% Off!
Books on similar topics, in best-seller order:Books from the same publisher, in best-seller order:
Finally, there's a book that treats Excel as the powerful development platform
it really is, and covers every facet of developing commercial-quality Excel applications.
This is not a book for beginners. Writing for professional developers and true
Excel experts, the authors share insider's knowledge they've acquired building
Excel applications for many of the world's largest companies—including
Microsoft. Professional Excel Development demonstrates how to get the utmost
from Excel, addressing everything from application architectures through worksheet
and userform design, charting, debugging, error handling and optimizing performance.
Along the way, the authors offer best practices for every type of Excel development,
from building add-ins through interacting with XML Web services. Coverage includes
- Building add-ins to provide new Excel functions
- Designing effective worksheets, userforms, and other user interface elements
- Leveraging Excel's powerful data analysis features
- Creating sophisticated custom charts
- Handling errors, debugging applications, and optimizing performance
- Using class modules and interfaces to create custom objects
- Understanding Windows API calls: when to use them, and how to modify them
- Adding worksheet functions with C-based XLLs
- Programming with databases
- Controlling external applications from Excel
- Integrating with Visual Basic 6, VB.NET and Visual Studio Tools for Office
- Using XML to import and export data and communicate with Web services
- Providing help, securing, packaging and distribution
CD-ROM INCLUDED
The accompanying CD-ROM contains the book's sample timesheet application at
every stage of construction, with detailed code comments. It also includes many
examples of the concepts introduced in each chapter and a collection of the
authors' Excel development utilities.
Table of Contents
1. Introduction.
2. Application Architectures.
3. Excel and VBA Development Best Practices.
4. Worksheet Design.
5. Function, General and Application-Specific Add-ins.
6. Dictator Applications.
7. Using Class Modules to Create Objects.
8. Advanced Command Bar Handling.
9. Understanding and Using Windows API Calls.
10. Userform Design and Best Practices.
11. Interfaces.
12. VBA Error Handling.
13. Programming with Databases.
14. Data Manipulation Techniques.
15. Advanced Charting Techniques.
16. VBA Debugging.
17. Optimizing VBA Performance.
18. Controlling Other Office Applications.
19. XLLs and the C API.
20. Combining Excel and Visual Basic 6.
21. Writing Add-ins with Visual Basic 6.
22. Using VB.NET and the Visual Studio Tools for Office.
23. Excel, XML and Web Services.
24. Providing Help, Securing, Packaging and Distributing.
About the Authors
Stephen Bullen is founder of Office Automation Ltd., a specialist
in Excel, Access and Visual Basic development that serves many of the world's
largest businesses. Rob Bovey is president of Application Professionals,
a software developer specializing in Microsoft Office, Visual Basic, and SQL
Server applications. He has developed several add-ins shipped by Microsoft with
Excel. John Green is founder of Execuplan Consulting, a specialist
in Excel and Access business application development. The authors have each
held Microsoft's coveted Excel MVP status for eight consecutive years, and are
coauthors of Excel 2000/Excel 2002 VBA Programmer's Reference (Wrox Press).
Customer Reviews
Customer Reviews: 1 Average Customer Rating: Aug 31, 2005
Finally! The sequel to Walkenbach for developers is here
If you cherished the Walkenbach's book for years and were longing for the advanced part to follow some day, you are there. So what if it is by different author. This is an outstanding book Buy the book even just for Chapter 20. Combining Excel and Visual Basic 6. The rumors about the death of VB6 are highly exaggerated. Even if you believe otherwise, the techniques described for using VB forms in VBA will give you a good grasp how to achieve the same thing with other languages. Basically, if you are a developer and were looking for a book to let you outgrow the limitations of VBA, this is THE BOOK. If you are a power user and would like to stay in confines of Excel and VBA, then most probably Walkenbach's book will be sufficient, although reading this book will give you an incentive to do more.
|
|
