Excel For Windows® 95 Power Programming with VBA [Paperback]

John Walkenbach (Author)

Book Description

ISBN-10: 0764530011 | ISBN-13: 978-0764530012 | Publication Date: June 13, 1996 | Edition: 2nd

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^™. 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

Editorial Reviews

About the Author

About the Author John Walkenbach is a spreadsheet consultant who has been writing about spreadsheets for over 12 years. He has published more than 250 articles and reviews on the subject, and is the author of several IDG Books bestsellers, including Excel 5 for Windows^® Power Programming Techniques^™, Excel for Windows^® 95 Bible, Excel For Dummies^® Quick Reference, 1-2-3^® For Dummies^®, and Quattro^® Pro For DOS For Dummies^®.

Product Details

• Paperback: 687 pages
• Publisher: Wiley; 2nd edition (June 13, 1996)
• Language: English
• ISBN-10: 0764530011
• ISBN-13: 978-0764530012
• Product Dimensions: 9.2 x 7.2 x 1.8 inches
• Shipping Weight: 4.4 pounds
• Average Customer Review: 4.6 out of 5 stars  See all reviews (11 customer reviews)
• Amazon Best Sellers Rank: #3,603,492 in Books (See Top 100 in Books)

More About the Author

John Walkenbach, a.k.a. Mr. Spreadsheet, is arguably the foremost authority on Excel. His fifty-plus books include Excel 2010 Power Programming with VBA, Excel 2010 Formulas, and the bestselling Excel 2010 Bible, all published by Wiley. He has also written hundreds of articles and created the award-winning Power Utility Pak.

Customer Reviews

Most Helpful Customer Reviews

15 of 16 people found the following review helpful:

5.0 out of 5 stars A solid book that gets the job done!, October 14, 1999

By 

John Leo Mencias (Belize) - See all my reviews

This review is from: Excel For Windows® 95 Power Programming with VBA (Paperback)

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.

6 of 6 people found the following review helpful:

4.0 out of 5 stars Excellent book., October 5, 1999

By 

David L. Charlesworth (Sugar Land, TX United States) - See all my reviews
(REAL NAME)   

Amazon Verified Purchase

This review is from: Excel For Windows® 95 Power Programming with VBA (Paperback)

I did not buy this book for a month because of some of the review comments, but then did go ahead and buy the book. I disagree with the negatives - this is an excellent book for anybody who has to write VB code for Excel. And there aren't THAT many bugs in the code, and those that are there are very minor. The comment about the "help" is unwarranted - I've been living in the "help" for two months now. Of the 3 books I have on this topic, this is the best one.

3 of 3 people found the following review helpful:

5.0 out of 5 stars An excellent guide for custom application development, June 4, 1998

By 

S. Davis (Elmwood Illinois) - See all my reviews
(REAL NAME)   

This review is from: Excel For Windows® 95 Power Programming with VBA (Paperback)

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.