Professional Excel Development : The Definitive Guide to Developing Applications Using Microsoft(R)

Description

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.

http://www.uploading.com/?get=P8X9JEGK

Disclaimer:
Contents of this page are indexed from the Internet. All actions are under your responsability. Email us to report illegal contents or external links and we'll remove them immediately.

Please check the description for download links if any or do a search to find alternative books.

Can't Download?
Please search mirrors if you can't find download links for "Professional Excel Development : The Definitive Guide to Developing Applications Using Microsoft(R)" in "Description" and someone else may update the links. Check the comments when back to find any updates.

Search Mirrors
Maybe some mirror pages will be helpful, search this book at top of this page or click here to find more info.

1. Ebooks list page : 375
2. Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft(R) Excel and VBA(R)
3. Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft(R) Excel and VBA(R)
4. Professional Excel Development: Definitive Guide to Developing Applications Using Microsoft Excel and VBA
5. Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel and VBA
6. Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel and VBA (repost)
7. Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel and VBA
8. Professional Excel Development: The Definitive Guide to Developing Applications Using ...
9. Professional Excel Development: The Definitive Guide to Developing Applications... (Repost)
10. Professional Excel Development: The Definitive Guide to Developing Applications
11. MSDN Training. Developing Microsoft ASP.NET Web Applications Using Visual Studio .NET. Delivary Guide.
12. Developing Scalable Series 40 Applications: A Guide for Java Developers (Nokia M
13. The Definitive Guide to Excel VBA
14. Definitive Guide to Excel VBA (Re Up)
15. Professional Excel Development
16. Professional.Excel.Development