Review of Excel Programming: Your visual blueprint for creating interactive spreadsheets (Paperback)

For some time, I have wanted to program in Visual Basic for Applications as a means to automate Excel 2000/2002.I have looked at many titles in the bookstore by various authors (experts in the field, unquestionably), but none seem targeted to the novice or intermediate user who simply wants to understand the VBA environment and how to benefit from its powerful capabilities.If other books were trying to target such an audience, then they suffered from poor readability and simply too much material. This book instills confidence in novice users as the reader is given very succinct explanations on variables, procedures, subroutines/functions, and, of course, the Excel Object Model.I have not been able to put the book down, practically speaking.

Extremely well organized, with generally very good and detailed graphics. It makes its point in roughly 325 pp. and features an excellent appendix dealing with constants, etc. I believe this book will forever relegate the more pricey books I have on the subject to a shelf in my technical library.The others are authoritative books, to be sure, but I never gained confidence with the format. Reading other sources proved exhausting when compared to this book.As an Excel user who wrote some macros in the Excel 95 version of the software, this book is a welcome addition.The book contains probably a few typos, and perhaps an illustration or two (screen shots of the Excel or VB Editor interface) is unclear or improperly rendered(such as in the section "Remove a Module"). Minor, minor details that won't matter in the overall scheme of things - this book rates very high in my opinion. Another plus: the CD ROM has the sample code used in many sections in the book as well as an "e-version" of the book itself.

Product Description
Excel(r) Programming 2nd Edition

Welcome to the only guidebook series that takes a visual approach to professional-level computer topics. Open the book and you'll discover step-by-step screen shots that demonstrate over 120 key Excel programming techniques, including:
* Creating and launching keyboard shortcuts
* Setting macro security
* Assigning a digital signature
* Developing a function with VBA
* Displaying a built-in dialog box
* Converting a list into an array
* Using the msgbox function
* Processing a runtime error
* Saving a workbook in a specified format
* Finding the intersection of two ranges

From the Back Cover
Excel^® Programming 2nd Edition

Welcome to the only guidebook series that takes a visual approach to professional-level computer topics. Open the book and you'll discover step-by-step screen shots that demonstrate over 120 key Excel programming techniques, including:

• Creating and launching keyboard shortcuts
• Setting macro security
• Assigning a digital signature
• Developing a function with VBA
• Displaying a built-in dialog box
• Converting a list into an array
• Using the msgbox function
• Processing a runtime error
• Saving a workbook in a specified format
• Finding the intersection of two ranges

Click Here to see more reviews about: Excel Programming: Your visual blueprint for creating interactive spreadsheets (Paperback)