Professional Excel Development - Stephen Bullen , Rob Bovey , John... - Librairie Eyrolles
Tous nos rayons

Déjà client ? Identifiez-vous

Mot de passe oublié ?

Nouveau client ?

CRÉER VOTRE COMPTE
Professional Excel Development
Ajouter à une liste

Librairie Eyrolles - Paris 5e
Indisponible

Professional Excel Development

Professional Excel Development

The Definitive Guide to Developing Applications Using Microsoft Excel and VBA

Stephen Bullen, Rob Bovey, John Green

914 pages, parution le 10/03/2005

Résumé

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.

L'auteur - 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.

L'auteur - Rob Bovey

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.

L'auteur - John Green

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

Autres livres de John Green

Sommaire

  • Acknowledgments
  • About the Authors
  • Introduction
  • Application Architectures
  • Excel and VBA Development Best Practices
  • Worksheet Design
  • Function, General and Application-Specific Add-ins
  • Dictator Applications
  • Using Class Modules to Create Objects
  • Advanced Command Bar Handling
  • Understanding and Using Windows API Calls
  • Userform Design and Best Practices
  • Interfaces
  • VBA Error Handling
  • Programming with Databases
  • Data Manipulation Techniques
  • Advanced Charting Techniques
  • VBA Debugging
  • Optimizing VBA Performance
  • Controlling Other Office Applications
  • XLLs and the C API
  • Combining Excel and Visual Basic 6
  • Writing Add-ins with Visual Basic 6
  • Using VB.NET and the Visual Studio Tools for Office
  • Excel, XML and Web Services
  • Providing Help, Securing, Packaging and Distributing
  • Index
Voir tout
Replier

Avis des lecteurs

5 / 5

Note basée sur 1 commentaire (voir tous les commentaires)

Ajouter votre commentaire
Commentaire de A
publié le 12/11/2005
Acheteur vérifié

Intérêt du livre

Ce livre est destiné à tous les utilisateurs avancés de la programmation sous VBA et permet à la fois de consolider ses connaissances et de continuer à progresser sur des sujets comme les modules de classe, l'utilisation de COM, etc. C'est un très bon livre, complet, précis et dense, à l'image de ce que ces auteurs ont toujours publié jusqu'ici. Je fais mieux que le conseiller. Je le recommande à 100%.

Caractéristiques techniques

  PAPIER
Éditeur(s) Addison Wesley
Auteur(s) Stephen Bullen, Rob Bovey, John Green
Parution 10/03/2005
Nb. de pages 914
Format 17,5 x 23
Couverture Broché
Poids 1333g
Intérieur Noir et Blanc
EAN13 9780321262509
ISBN13 978-0-321-26250-9

Avantages Eyrolles.com

Livraison à partir de 0,01 en France métropolitaine
Paiement en ligne SÉCURISÉ
Livraison dans le monde
Retour sous 15 jours
+ d'un million et demi de livres disponibles
satisfait ou remboursé
Satisfait ou remboursé
Paiement sécurisé
modes de paiement
Paiement à l'expédition
partout dans le monde
Livraison partout dans le monde
Service clients sav@commande.eyrolles.com
librairie française
Librairie française depuis 1925
Recevez nos newsletters
Vous serez régulièrement informé(e) de toutes nos actualités.
Inscription