What do you think?
Rate this book
Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel and VBA
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
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
Kindle Edition
First published February 1, 2005
27 people are currently reading
179 people want to read
Ratings & Reviews
Friends & Following
Create a free account to discover what your friends think of this book!
Community Reviews
Displaying 1 - 4 of 4 reviews
February 25, 2010
A bit overwhelming with all the information in this book but definitely worth the read. I'll be going back into when I implement a lot of his ideas.
November 6, 2014
Very complete. I was able to find some answers to punctual questions; but I have to confess that I decided to go on with less heavy reading for the rest of the time.
***
Editing after comment from Mike: yes, this book is mote useful when interested in building VBA enhancements to excel workbooks. My three-star rating -which I am standing by comes from the fact that I do not regard Excel as a reliable tool for developers. I think that it would be cool to have some level of knowledge on coding "tricks", but if the start point is a platform so unreliable and unstable as MICROSOFT Excel, then we are not prone to good things. All that said, it is not the book's fault that I don't like Excel, so an additional argument for the low rating ought to exist; and here it is: what I really disliked was the solipsistic air of superiority that emanated from the writing. A message in the direction of "Excel is the best tool if only you knew to take better advantage of it". My personal experience is this: Excel is nice and useful, and you can do cool things with VBA, but it is also unstable, and things get broken for no reason (example: tables and pivot fields) and if you want to use programming techniques to enhance your work, you better move on to more elaborated and robust tools.
***
Editing after comment from Mike: yes, this book is mote useful when interested in building VBA enhancements to excel workbooks. My three-star rating -which I am standing by comes from the fact that I do not regard Excel as a reliable tool for developers. I think that it would be cool to have some level of knowledge on coding "tricks", but if the start point is a platform so unreliable and unstable as MICROSOFT Excel, then we are not prone to good things. All that said, it is not the book's fault that I don't like Excel, so an additional argument for the low rating ought to exist; and here it is: what I really disliked was the solipsistic air of superiority that emanated from the writing. A message in the direction of "Excel is the best tool if only you knew to take better advantage of it". My personal experience is this: Excel is nice and useful, and you can do cool things with VBA, but it is also unstable, and things get broken for no reason (example: tables and pivot fields) and if you want to use programming techniques to enhance your work, you better move on to more elaborated and robust tools.
July 16, 2013
If you're serious about becoming a professional Excel developer then this book is a must have!
May 22, 2014
Libro interessante e ricco di spunti, ma da leggere solo da utenti avanzati perché dà molte cose non banali per assodate
Displaying 1 - 4 of 4 reviews