Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel and VBA

Valutazione media 3,94
( su 89 valutazioni fornite da Goodreads )
 
9780321262509: Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel and VBA

Enterprise-Class Excel Programming, from Start to FinishFinally, 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. 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 distributionCD-ROM INCLUDEDThe 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.(c) Copyright Pearson Education. All rights reserved.

Le informazioni nella sezione "Riassunto" possono far riferimento a edizioni diverse di questo titolo.

From the Back Cover:

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.

About the Author:

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).


© Copyright Pearson Education. All rights reserved.

Le informazioni nella sezione "Su questo libro" possono far riferimento a edizioni diverse di questo titolo.

I migliori risultati di ricerca su AbeBooks

1.

Bullen, Stephen, Bovey, Rob, Green, John
Editore: Addison-Wesley Professional (2005)
ISBN 10: 0321262506 ISBN 13: 9780321262509
Nuovi Paperback Quantità: 2
Da
Murray Media
(North Miami Beach, FL, U.S.A.)
Valutazione libreria
[?]

Descrizione libro Addison-Wesley Professional, 2005. Paperback. Condizione libro: New. Codice libro della libreria P110321262506

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 44,45
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 2,56
In U.S.A.
Destinazione, tempi e costi

2.

Bullen, Stephen; Bovey, Rob; Green, John
Editore: Addison-Wesley Professional
ISBN 10: 0321262506 ISBN 13: 9780321262509
Nuovi PAPERBACK Quantità: 1
Da
Cloud 9 Books
(Wellington, FL, U.S.A.)
Valutazione libreria
[?]

Descrizione libro Addison-Wesley Professional. PAPERBACK. Condizione libro: New. 0321262506 New Condition. Codice libro della libreria NEW6.0148403

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 61,81
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 4,28
In U.S.A.
Destinazione, tempi e costi

3.

Stephen Bullen, Rob Bovey, John Green
Editore: Addison-Wesley Professional (2005)
ISBN 10: 0321262506 ISBN 13: 9780321262509
Nuovi Paperback Quantità: 1
Da
Ergodebooks
(RICHMOND, TX, U.S.A.)
Valutazione libreria
[?]

Descrizione libro Addison-Wesley Professional, 2005. Paperback. Condizione libro: New. PAP/CDR. Codice libro della libreria DADAX0321262506

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 83,51
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 3,42
In U.S.A.
Destinazione, tempi e costi