Professional Excel Development: The Definitive Guide To Developing Applications Using Microsoft Excel And Vba - Couverture souple

Bullen, Stephen; Bovey, Rob; Green, John

Couverture souple

ISBN 10 : 0321262506 ISBN 13 : 9780321262509

Editeur : Addison-Wesley Educational Publishers Inc, 2005

Synopsis

Professional Excel Development Written for professional developers and Excel experts, this book 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. It also includes a CD-ROM which contains the book's sample timesheet application. Full description

A propos du livre

Quatrième de couverture :

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 distributing

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.

© Copyright Pearson Education. All rights reserved.

Présentation de l'éditeur :

Microsoft Excel can be much more than just a spreadsheet. It has become a

development platform in it own right. Applications written using Excel are part

of many corporations' core suites of business-critical applications. In spite of

this, Excel is too often thought of as a hobbyist's platform. While there are

numerous titles on Excel and VBA, until now there have been none that

provide an overall explanation of how to develop professional-quality Excelbased

applications. All three authors are profesional Excel developers who run

their own companies developing Excel-based apps for clients ranging from

individuals to the largest multinational corporations. In this book they show

how anyone from power users to professional developers can increase the

speed and usefulness of their Excel-based apps.

À propos de cette édition

• Éditeur: Addison-Wesley Educational Publishers Inc
• Date d'édition: 2005
• ISBN 10: 0321262506
• ISBN 13: 9780321262509
• Reliure: Broché
• Nombre de pages: 936