|
|
Usually ships within 2 to 4 working days
|
- Product code: 21533
- ISBN: 0321262506,
ISBN13: 9780321262509,
936 pages, paperback
Published by Addison Wesley on 2005
, New title Rate this book...
Rating: 4.0/5 (2 votes cast)
|
|
|
|
|
Description of Professional Excel Development |
Microsoft Excel can be much more than just a spreadsheet. It has become adevelopment platform in it own right. Applications written using Excel are partof many corporations' core suites of business-critical applications. In spite ofthis, Excel is too often thought of as a hobbyist's platform. While there arenumerous titles on Excel and VBA, until now there have been none thatprovide an overall explanation of how to develop professional-quality Excel-basedapplications. All three authors are professional Excel developers who runtheir own companies developing Excel-based apps for clients ranging fromindividuals to the largest multinational corporations. In this book they showhow anyone from power users to professional developers can increase thespeed and usefulness of their Excel-based apps.
|
Contents of Professional Excel Development |
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. Using Windows API Calls
10. Userform Design and Best Practices
11. Interfaces
12. VBA Error Handling
13. Programming with Databases
14. Data Analysis Methods
15. Presentation Techniques
16. VBA Debugging
17. Optimizing VBA Performance
18. Controlling Other 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 Rob Bovey, John Green and Stephen Bullen |
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). A(c) Copyright Pearson Education. All rights reserved.
|
Buyers of Professional Excel Development also bought
Bulk buying
| If you need bulk copies of Professional Excel Development, or are interested in opening a corporate account, please contact us. |
|
|
Shopping basket