Excel for Windows? 95 Power Programming with VBA

by John Walkenbach

Book Overview

Excel for Windows? 95 Power Programming with VBA 2nd Edition Turn your intermediate Excel knowledge into power-user prowess with this completely revised and updated edition of the bestselling Excel 5... This description may be from another edition of this product.

• Format: Paperback
• Language: English
• ISBN: 0764530011
• ISBN13: 9780764530012
• Release Date: June 1996
• Publisher: Wiley
• Length: 687 Pages
• Weight: 2.65 lbs.
• Dimensions: 1.8" x 7.3" x 9.2"

Customer Reviews

Always on my desk

I am constantly using this book for reference and rarely do I not find an answer I am looking for.

A solid book that gets the job done!

Let me put this in clear, concise and 'hands-on' language. Before reading this book, I knew little about VBA. Right after reading it (and actually working through 80% of its examples), I was able to build a custom mortgage analysis application using MS Excel as the user interface and MS Access as the data source. I was able to set up and manipulate dropdowns (comboboxes) within spreadsheet cells to present parameter choices, and to programmatically create and manipulate graphs and pivot tables to display results in more meaningful formats. I also made extensive use of arrays and functions to cope with the many iterative calculations required. To add to all this, I was able to use DAO to query and update the Access database. Since then, I have been working on VBA for Access etc., only to find out that the foundation laid by John Walkenbach carries over excellently to all MS Office applications.

This is THE Excel Programming book

Walkenbach is one of the best technical writers I have seen on any subject, and this book is a perfect example. Although allot has changed with Excel 97, most of the concepts I learned in this book apply nicely. This book is a great introduction to Visual Basic, but its also great for experienced VB Programmers using Excel.

An excellent guide for custom application development

The book was one of the most useful I read in learning to create Excel custom applications. It is written by some one who has actually struggled with making it really work. Other books often tell you VBA in Office has almost unlimited tools to accomplish a task and suggest VBA online help for further details, not a lot of help. The is written for Excel 95 not Excel 97 and needs an upgrade. Office 97 completely overhauled dialog boxes, toolbars, and custom menus. There are very few books that actually have the depth to help a serious designer of a VBA custom application, this is one. If you create Excel custom designs for others to use then add this book to your shelf.

Excellent technical writing.

Mr. Walkenbach understands the predicament of the reader who does not have the time to read, but yet, needs to become proficient in the subject matter. This, coupled with his knowledge of the subject and his literary ability makes for an enjoyable experience. When will we have an Excel 97 encore?