A guide to the development aspects of Excel covers such topics as building add-ins, creating custom charts, using class modules, handling errors, controlling external applications, and programming with databases.
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.