Excel for Windows 95 Power Programming with VBA

By John Walkenbach

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 for Windows? Power Programming Techniques(tm). Author John Walkenbach ("Mr. Spreadsheet") boosts your Excel productivity to new heights with total coverage of Excel for Windows 95's powerful new features and the popular Visual Basic for Applications (VBA). With Walkenbach's expert guidance and exclusive Power Utility Pak on CD-ROM, you'll soon be exploiting VBA's power to create dynamic, customized spreadsheets in Excel for Windows 95. Turn up the juice on your spreadsheets with this ultimate, updated resource! Create powerful spreadsheets with VBA and the Power Utility Pak! Delve into Data Access Object and Compatibility issues with two ALL-NEW chapters packed with practical answers Quickly pick up Visual Basic for Applications (VBA) with the extensive code examples and in-depth coverage throughout Turn up the power on your Excel applications as you develop utilities, 3-D charts, and more with VBA Streamline your work with up-to-the-minute coverage of the new Data Access Object feature that simplifies the process of working with external database files in VBA Collect expert tips and techniques for Excel Application Development and make use of the best tips and tricks for interacting with other applications Create custom menus, toolbars, help applications, and more! Excel for Windows? 95 Power Programming with VBA, 2nd Edition has been completely updated for the release of Windows 95, with two entirely new chapters: Using the Data Access Object and Compatibility Issues. In addition to the thorough coverage of application development with Excel, you will find extensive information on the popular Visual Basic for Applications feature. Power Programming CD-ROM features a blockbuster assortment of shareware: Add voltage to your spreadsheets with the Power Utility Pak Run with 22 new worksheet functions: Navigate through multiple workbooks and worksheets Track time spent on projects Insert a string Size or shape an object Save typing time with code and examples from the book Platform and System Requirements: Excel for Windows 95, Windows 95

• 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?