Excel 97 Programming for Windows For Dummies [Paperback]

John Walkenbach (Author)

Book Description

ISBN-10: 0764501321 | ISBN-13: 978-0764501326 | Publication Date: June 19, 1997 | Edition: 1

By itself, Excel 97 can do some pretty amazing stuff. Add Visual Basic for Applications (VBA) and you add a whole other dimension of automation and customization. Excel 97 Programming For Windows For Dummies offers plenty of practical examples of Excel programming in action and explains in plain English how to
* Save time and improve accuracy by automating common tasks
* Design custom dialog boxes to suit your and your organization's needs
* Build specialized functions to use in your worksheets
* Create add-ins, take advantage of the Windows API, and define custom data types
With numerous books and articles on Excel to his credit, John Walkenbach is the ideal author to make Excel programming understandable, whether you're new to programming or just new to this latest release of Excel.

Editorial Reviews

From the Back Cover

Tips and tricks for writing powerful macros with VBA!

Your first aid kit^® for designing user-friendly applications

Find out how to create custom dialog boxes, toolbars, menus, and more! If you want to write programs that perform time-consuming procedures in a snap, then this is the book for you! Inside you'll find explanations on how Visual Basic for Applications works with Excel, how-to guidance on Visual Basic Editor, and tried-and-true tips to help you write and run some really cool macros.

Discover how to: Make your VBA code run with speed Enhance spreadsheet functionality Create custom add-ins Modify an objects properties Debug your applications Add online help features to worksheets

The Dummies Way^™ Explanations in plain English "Get in, get out" information Icons and other navigational aids Tear-out cheat sheet Top ten lists A dash of humor and fun

Get smart! www.dummies.com Register to win cool prizes Browse exclusive articles and excerpts Get a free Dummies Daily^™ e-mail newsletter Chat with authors and preview other books Talk to us, ask questions, get answers

About the Author

John Walkenbach has written hundreds of articles and numerous books, including Microsoft?? Excel 2000 Formulas. He is the principal of JWalk Associates, a spreadsheet application development company.

Product Details

• Paperback: 300 pages
• Publisher: For Dummies; 1 edition (June 19, 1997)
• Language: English
• ISBN-10: 0764501321
• ISBN-13: 978-0764501326
• Product Dimensions: 9.2 x 7.4 x 1 inches
• Shipping Weight: 1.6 pounds (View shipping rates and policies)
• Average Customer Review: 4.3 out of 5 stars  See all reviews (17 customer reviews)
• Amazon Best Sellers Rank: #2,194,903 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

19 of 19 people found the following review helpful:

4.0 out of 5 stars A great book to help you get started with Excel programming., May 10, 1999

By A Customer

This review is from: Excel 97 Programming for Windows For Dummies (Paperback)

As an "intermediate" user of Excel, I needed a fairly easy to use book to help me get started with writing macros in Excel. This book fit my need very well. You will not by any means be an expert in Excel programming after you use this book, but you will definitely be able to write (not just record) macros with confidence as a result of this book. I recommend it highly as a first book for "beginner" to "intermediate" users of Excel who want to quickly begin writing their own macros.

10 of 10 people found the following review helpful:

5.0 out of 5 stars Great Info with an excellent presentation!, March 22, 1999

By 

[e-mail] (Corvallis, Oregon) - See all my reviews

This review is from: Excel 97 Programming for Windows For Dummies (Paperback)

This book is wonderful -- I was able to dig in right away! I had a huge data table of mixed text and numbers that I needed to rearrange for statistical analysis, and I was able to quickly learn enough VBA to program what I needed to get the job done. Now I have been going back through the book to find out what other neat stuff I can do -- I am learning a lot more about Excel along the way. I have wanted to know how to program Excel for a long time, and finally here is a very good way to help me learn without an enormous time investment. As I read the book, I get the feeling that I am sitting at a co-worker's desk and watching while he/she explains VBA to me. Very user-friendly. I originally had bought the Microsoft Step-by-Step book, but returned it after reading another review above. This ForDummies book is much better as a reference. One critique is that I would like to see an appendix with a listing of all posssible object properties and methods.

8 of 8 people found the following review helpful:

2.0 out of 5 stars Not as useful as I hoped, May 23, 2001

By 

Michael Mach (Cedar Rapids, IA United States) - See all my reviews
(REAL NAME)   

Amazon Verified Purchase

This review is from: Excel 97 Programming for Windows For Dummies (Paperback)

Despite the high recommendations of some other users, this book is not as helpful as I wanted. Yes, it gives a good overview of VBA programming in Excel, but it is short on detailed, technical information - the type of information you need in order to actually write workable code. It spends very little time talking about manipulating data within Excel. This book often refers the reader to the online help. If I wanted to use the online help I would not have bought a book. It also expects you to use the macro recorder as a crutch until you learn enough to write code on your own. A good book if you want a high level overview of VBA, but probably not if you need to write lines of code.