It seems like it'd be great if you're already an expect macro writer and just need a reminder about what certain functions do. If that's not you, then this book is probably not for you.

This book is a refreshing change from the 1000+ page manuals you often see when you are looking for a technical reference book. The author's philosophy is such that he doesn't resort to handholding, nor does he try to explain every last nuance of an application. Instead, he gives a concise explanation of the material, and builds upon the information as you go. When you are done with the material, you should have the basic knowledge you need to be productive immediately, as well as the tools you need to delve further into VBA and Excel programming.

The first part of the book shows you the editing environment used to program Excel. Once you have that down, he explains the basics of VBA. VBA, or Visual Basic For Applications, is a subset of the Visual Basic language, and is well suited for scripting activities within an application object model. Once you understand all that, you start putting that newly acquired information to work by creating Excel applications that allow you to automate functions within Excel.

OK, now back to the Notes/Domino world. Why do you need to know anything about Excel and how to program it? It depends if you want to really want to extend the power of Notes. With LotusScript, you can create an Excel object in code using COM technology. Once you have the Excel object declared, you could use LotusScript to start manipulating the properties and methods of all the Excel objects. So for instance, you could build an agent that would read all the documents in a view and create a simple Excel spreadsheet without having the user work through the cumbersome view export menu option. Or to be more impressive, you could use the Excel object model within LotusScript to create monthly reports with all the formatting you would normally do manually within Excel. This keeps the user from having to manually transfer data from one application to another.

So why this book? To effectively program LotusScript and Excel, you MUST understand the object model of the application. If you don't understand the object hierarchy of Excel, it makes it nearly impossible to do anything more than the simplest of tasks. The author does a great job of explaining the different objects in Part 3 of the book. While not all of the objects are applicable to your Notes/Domino programming, most of the material will give you the information you need to understand where to start and to figure out what is possible.

Conclusion
I recommend this book to any Notes/Domino developer who wants to create applications that interface with Excel. Other books concentrate too much on how to work with Excel as an application. This book gives you the tools you need to work with Excel as a programmable tool.