Customer Reviews

Microsoft Excel 97 Developer's Handbook: With CDROM

5 star:		(4)
4 star:		(1)
3 star:		(2)
2 star:		(1)
1 star:		(1)

 

 

My review is based on Parts One and Two of the book.

Part One: Introduction is useful for the beginner, and the techniques are illustrated with a simple "West Coast Airways" example that is introductory, but a good training exercise for understanding the use of buttons etc. A "splash screen" is used with CommandButtons. Part Two, Ch 5, Custom Interface Design, describes a "Wellington Cycle Works" application that hides the natural EXCEL interface. User Forms are applied. Part Three, Database Access, I haven't explored. It also contains an example application, the "Setagaya Cycle" (a competitor of Wellington Cycle), which uses a database to generate a sales forecast with pivot tables, goal seek and some other functionality of EXCEL. Part Four discusses integration with Access, Word and PowerPoint. It also discusses web application. I haven't looked at this part of the book, which also contains the "Pacific Industries" application that uses Access and Word to generate reports, queries external databases, uses the office assistant to guide the user, and so forth.

I am impressed with the authors' clarity of explanation and the examples that show how to use the various tools available.

The book is very approachable. Unlike books like Kofler's "Definitive Guide" and Walkenbach's "Power Programming", the complete working examples allow the reader to see how different facets of the program can be combined. You can see how features work together. The way is clear to adapt to your own requirements.

This is a great introduction to using Excel to create business solutions. Despite its age, it's still the best discussion I've seen of Excel's greatest feature: the Pivot Table. What I really like about this book is its methodical discussion of particular objects properties and methods--yes, I do think there is a place for books that 'regurgitate' information that's in the help files; help files are too fragmented to gain a meaningful overview of an object model. On the subject of objects though there isn't a sniff of a class module in this book, and that's a shame because if you want to do anything complex with VBA you'll certainly need to know about them. Read this with Jacobson's Excel Visual Basic and follow it up with Wrox's Excel VBA 2002 and you should know all you'll ever need about Excel and VBA.

All concepts we need when building pivot tables and dynamic graphics are very clearly explained; The samples are very usefull and can be used as standard applications solving most of problems we have.

As a beginner using Excel macro for building decision-making tools for scientific purpose, I should vote this book No.1 after reading several related publications. The fundamental VBA concepts were clearly explained; the practical strategies were nicely illustrated with the accompanied sample applications. The issue of using Excel inside Web-browser is exceptionally explained, with lots of insightful tips. I am looking forwards to reading an equivalent guide on Excel 2000 VBA!

This is a fairly good book for those that want to learn VBA in the Excel environment period. Want to learn more powerful features find a better book.

...such as pivot tables and customising the Excel environment. The other topics in the book aren't covered in as much detail. The section on DAO is little more than a description of the objecy model, with few useful samples, and why is there no mention of using class modules?

This book has excellent promise as far as the topics covered. However, it merely shows you what can be done, without explaining how to do it. There is much reference to VBA, but very little sytax and coding help. I was very disappointed.

This is perhaps the worst book written for people aspring to do Excel programming. Given Excel's powerful features and rich programming environment, I am appalled by extremely supreficial treatment of the subject. I am also quite dismayed by the very bad coding conventions used by both authors.

As an Excel developer I always look for books to recommend to my users so as to better communicate business and programming concepts. I am finding myself recommending VBA books written for Access rather than Excel.

Great book, its where I learned Excel and VBA

Probably a lot has changed now but its a terrific book