Excel 2002 Power Programming with VBA (Paperback)

by John Walkenbach (Author) "To fully appreciate the application development features available in Excel 2002, it's important to understand where this product came from and how it fits into..." (more)
Key Phrases: last nonempty cell, loan amortization wizard, current range selection, End Sub, Private Sub, End Function (more...)

Editorial Reviews

Product Description
Get the most out of Excel, Microsoft's powerful spreadsheet application. With John Walkenbach, the leading Excel expert better known as "Mr. Spreadsheet", discover better ways to analyze data and find solutions using Microsoft Excel 2002.

This book is an excellent resource for getting up to speed using streamlined spreadsheet creation tools, enhanced analysis tools and powerful Web integration. Transform Excel into an application suited to the whole organization so workgroups can work more effectively. Discover how developers can integrate information seamlessly, whether proposal text, financial figures or research data. Whether you are an expert or a novice, Excel 2002 Power Programming with VBA will help you work more efficiently, turning your data into answers you can count on.

Bonus: The book contains a coupon for the Professional Power Utility Pak.

From the Back Cover
Excel 2002 Power Programming with VBA Develop Powerful, User-Oriented Excel 2002 Applications With this unique guide, renowned spreadsheet authority John Walkenbach invites you to harness the full potential of Excel—and join the elite group of users and developers who truly understand what the product is capable of. Offering plenty of detailed, well-thought-out examples, he walks you through the basics of Excel application development and VBA programming—and then gives you a lucid, wide-ranging seminar on advanced programming techniques and application development issues. It's all you need to create user-oriented custom applications that leverage the power of Excel 2002. Your Road Map to Excel Application Development

• Take Excel to the next level with formula tricks and techniques
• Work with VBA sub procedures and function procedures
• Create stellar UserForms as well as custom dialog box alternatives
• Develop applications that maximize the power of PivotTables and charts
• Incorporate event-handling and interactions with other applications
• Build user-friendly toolbars, menus, and help systems
• Manipulate files and Visual Basic components and understand class modules
• Get advice on compatibility issues and answers to frequently asked Excel programming questions

Bonus CD-ROM Includes

• A trial version of the author's award-winning Power Utility Pak 2000
• A demo of the author's Sound-Proof 2000
• Over 175 example Excel workbooks from the book

System Requirements: Pentium PC with Windows 98 or greater; 32 MB RAM; Microsoft Excel 2002. See About the CD appendix for details and complete system requirements.

See all Editorial Reviews

Product Details

• Paperback: 984 pages
• Publisher: Wiley (July 15, 2001)
• Language: English
• ISBN-10: 0764547992
• ISBN-13: 978-0764547997
• Product Dimensions: 9.2 x 7.4 x 2.1 inches
• Shipping Weight: 3.2 pounds (View shipping rates and policies)
• Average Customer Review: 3.8 out of 5 stars See all reviews (23 customer reviews)
• Amazon.com Sales Rank: #351,255 in Books (See Bestsellers in Books)

  Popular in these categories: (What's this?)

  #15 in	Books > Computers & Internet > Microsoft > Spreadsheets
  #51 in	Books > Computers & Internet > Programming > Languages & Tools > Basic
  #68 in	Books > Computers & Internet > Microsoft > Development > VBA

Customer Reviews

Most Helpful Customer Reviews

45 of 46 people found the following review helpful:

5.0 out of 5 stars Great book--highly recommended, August 31, 2002

By	macktheknife (Northern, CA) - See all my reviews

I am a real estate finance analyst and researcher who wanted more control over the manipulation of my data in Excel as well as learning how to create user forms. John Walkenbach's "Excel 2002 Power Programming with VBA" was an informative and excellent resource that taught me most of what I was looking for. Walkenbach begins with a brief explanation of Excel and the fundamentals of object-oriented programming (OOP), which underpins VBA. The reader has to be patient and be willing to experiment; working through Walkenbach's examples with Excel open is almost a must.

There are several issues that I would like to point out. One reviewer was upset over the fact that Walkenbach did not offer some utilities from the book's CDs for free. I did not try any of the utilities because I was more interested in the book's actual contents and explanations. Walkenbach does, however, offer the reader a full and unrestricted PDF version of the book in the CD, which I think is mighty generous of him. Instead of lugging the +1,000 page book, I sometimes leave the PDF version on my laptop so I could always have it with me. Lastly, I use Excel 97 at work and Excel X on the Mac at home, and despite some minor incompatibility issues, I would say that the book for the most part could be used for all versions of Excel 97 and up.

BTW, I would also recommend "Excel 2002 VBA" by Bullen, Green, Bovey, and Rosenberg published by Worx Press for a more advanced treatment of VBA.

30 of 32 people found the following review helpful:

4.0 out of 5 stars A well written book, July 22, 2002

By	Antonios Giannakas (New York, NY United States) - See all my reviews

I went over this book twice. Although I believe I understood most of it, I am not yet a power programmer.
This book is an intermediate book on Excel programming. Don't expect to become an expert from it. The book is very well written and John Walkenbach writes in a way that no other programmer does. The book stimulates the interest of the reader into Excel. The examples are well explained. I did not give this book five stars because the Windows API is not explained in depth.
According to me the path of the books to Excel programming is:
1 Excel The Bible( the second half of the book)
2 Excel for Power Programmers
3 Excel 2002 VBA Programmer's reference
The last book in the list is not for inexperienced programmers and is not as pleasant to read( So do not start with it).
I also recommen Excel 2002 formulas if the would be programmer does not have an extensive experience in Excel

23 of 24 people found the following review helpful:

5.0 out of 5 stars A great book on VBA, March 2, 2002

By	Classic Style Seeker (Burlington, MA United States) - See all my reviews

I got this book and the author's other on Formulas. Although I am only using Excel 2000, I got it because I would be using Excel 2002 in the future. With no experience in VBA for MS apps, I needed something to get me up and running with writing macros from scratch. Familiar with VB6 I figure I can pick VBA up easily. I had a book on VBA from SAMS teach yourself series some years back, which I found dry and useless. I had thrown it away so I got this book.

I was up and running in about two hours writing macros that would look down a column of data and find the last non-empty cell in a range that had empty cells between data cells. I also wrote macros to update a summary at the top of the worksheet depending on how much data was in a particular row and to advance to the next empty cell in a row after data was entered, assisting the user in entering/selecting data.

Excellent and easy to understand. The real meat doesn't start until Chapter 7 when VBA is introduced. Prior to that is a refresher on formulas and Excel itself. I'm results oriented so I skimmed up to Chapter 7 before looking for answers to my problem. I am only in Chapter 9, before userforms, which is overkill for my needs at work but I will begin tinkering since it'll be done on my own time. Highly recommended for those who need a good solid intro to VBA. If you know VB, it'll be cake walk. For those who don't, there are plenty of examples to help you out and remember to understand the Excel object model. You should be all set if you at least try some of the examples instead of staring at the print.

The only thing I think is missing is a listing of the methods and properties of the Excel object model. For that, I have "Excel 2002 VBA" by Wrox. Funny how I've only used that book for its listing in its appendix, which is several hundred pages long and easily worth the price of that book. But that's another review...