Microsoft Excel 97 Developer's Handbook: With CDROM [Paperback]

Eric Wells (Author), Steve Harshbarger (Contributor)

Book Description

Publication Date: February 7, 1997

Organizations everywhere are discovering that Microsoft Excel is a powerful development tool--and now features important Intranet and Internet capabilities. That's why the third edition of this classic is the one-volume reference for application programmers who want fast, easy ways to produce custom business information solutions.

Product Details

• Paperback: 623 pages
• Publisher: Microsoft Press (February 7, 1997)
• Language: English
• ISBN-10: 1572313595
• ISBN-13: 978-1572313590
• Product Dimensions: 9.2 x 7.4 x 1.8 inches
• Shipping Weight: 3 pounds
• Average Customer Review: 3.7 out of 5 stars  See all reviews (9 customer reviews)
• Amazon Best Sellers Rank: #2,221,806 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

6 of 6 people found the following review helpful:

5.0 out of 5 stars Good Intro to EXCEL Applications Using VBA, July 31, 2001

By 

johare4 (Santa Fe, NM) - See all my reviews

This review is from: Microsoft Excel 97 Developer's Handbook: With CDROM (Paperback)

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.

5 of 5 people found the following review helpful:

4.0 out of 5 stars An oldie but a goodie, April 3, 2003

By A Customer

This review is from: Microsoft Excel 97 Developer's Handbook: With CDROM (Paperback)

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.

2 of 2 people found the following review helpful:

5.0 out of 5 stars Excellent for applications involving EIS and Data Analysis, January 26, 2000

By 

Marcio Antonio do Carmo Ferreira (Belo Horizonte, Brazil) - See all my reviews

This review is from: Microsoft Excel 97 Developer's Handbook: With CDROM (Paperback)

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.