Excel 2007 Power Programming with VBA (Mr. Spreadsheet's Bookshelf) (Paperback)

by John Walkenbach (Author)
Key Phrases: object library, sub procedures, loan amount, End Sub, Private Sub, Office Menu (more...)

Editorial Reviews

Product Description

• This book is a single reference that’s indispensable for Excel beginners, intermediate users, power users, and would-be power users everywhere
• Fully updated for the new release, this latest edition provides comprehensive, soup-to-nuts coverage, delivering over 900 pages of Excel tips, tricks, and techniques readers won’t find anywhere else
• John Walkenbach, aka "Mr. Spreadsheet," is one of the world’s leading authorities on Excel
• Thoroughly updated to cover the revamped Excel interface, new file formats, enhanced interactivity with other Office applications, and upgraded collaboration features
• Includes a valuable CD-ROM with templates and worksheets from the book

Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

From the Back Cover
Expand Excel with VBA, and feel the power!

No one is better at revealing the secrets of Excel than "Mr. Spreadsheet" himself. This power-user's guide is packed with procedures, tips, and ideas for expanding Excel's capabilities with Visual Basic® for Applications. Excel 2007 has a few new tricks up its sleeve, and John Walkenbach helps you make the most of them all.

You'll learn to customize Excel UserForms, develop new utilities, use VBA with charts and PivotTables, and create event-handling applications. Work with VBA subprocedures and function procedures, facilitate interactions with other applications, build user-friendly toolbars, menus, and help systems, and much more. Get ready to make Excel do your bidding.

Mr. Spreadsheet's POWER TIPS:

Power Tip #1 Create powerful Excel applications

Power Tip #2 Enhance Excel with VBA macros

Power Tip #3 Write event-driven VBA code

Power Tip #4 Understand the new Excel 2007 ribbon

Power Tip #5 Expand Excel's shortcut menus

CD-ROM INCLUDES:

• Valuable sample files that illustrate examples from the text

• A searchable PDF version of the book

See the CD appendix for details and complete system requirements.

See all Editorial Reviews

Product Details

• Paperback: 1104 pages
• Publisher: Wiley (April 16, 2007)
• Language: English
• ISBN-10: 0470044012
• ISBN-13: 978-0470044018
• Product Dimensions: 9.2 x 7.3 x 2.5 inches
• Shipping Weight: 2.9 pounds (View shipping rates and policies)
• Average Customer Review: 4.2 out of 5 stars See all reviews (30 customer reviews)
• Amazon.com Sales Rank: #4,578 in Books (See Bestsellers in Books)

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

  #1 in	Books > Computers & Internet > Microsoft > Development > VBA
  #10 in	Books > Computers & Internet > Microsoft > Applications > Excel
  #10 in	Books > Computers & Internet > Software > Spreadsheets

Customer Reviews

Most Helpful Customer Reviews

39 of 41 people found the following review helpful:

5.0 out of 5 stars 5 stars in spite of the misleading title, November 28, 2007

By	Paul O'Connor (Minneapolis, MN) - See all my reviews (REAL NAME)

This is a GREAT introduction to ALL aspects of Excel and VBA. Most people who need this book come into VBA from other experiences and have rarely taken classes in VBA and they need a readable reference that can bring them up to speed on the parts they don't understand yet.

Used this way the book is simply outstanding and most users probably don't need anything more than this book, but I'm not one of those people.

I purchased "Professional Excel Development" by Bullen, Bovey, and Green at the same time and was awestruck at the depth of their knowledge and their passion for making Excel the only development tool your company will ever need. In short they are absolutely insane in a very knowledgeable and useful way.

The biggest problem with "Professional Excel Development" is that readers are expected to know a LOT more about Excel and VBA than average and Walkenbach nicely addresses that issue. He's also a lot more readable than the other authors and so can be used in conjunction with them to clarify the points that they are making.

Regardless of how you use this book, it is a very good for just about any level of VBA developer and firmly earns the 5 star rating.

32 of 35 people found the following review helpful:

4.0 out of 5 stars The CD included with my book had no searchable .PDF file :-(, April 17, 2007

By	M. McClure "Big 4 CPA" (Bethesda, MD) - See all my reviews (REAL NAME)

I really enjoyed John's "Excel 2003 Power Programming with VBA" and I was looking forward to giving his 2007 edition an enthusiastic 5 stars. I have read Excel books by other authors, and no one seems to present the material as clearly as John does. However, when I received the book I was very disappointed to find out that the CD-ROM included with the book did not contain a searchable .PDF version of the book as advertized. Instead, there was a one page .PDF file on the CD with the following text: "This is just a Placeholder. Actual PDF is not ready yet - Media Development." If having a searchable .PDF version of the book is as important to you as it is to me, I would suggest that you wait to purchase this book until you can confirm the books are shipping with the .PDF version on the CD as advertized.

Update: As mentioned by a reviewer above, the publisher can provide you with either a link to download the eBook or a CD with the eBook. After speaking with three customer service representatives I received (1) the same exact CD that came with the book, (2) a burned CD via mail with just the eBook, and (3) a link to download the eBook. It may take a day or two for them to provide it to you, but it is possible to obtain the eBook from the publisher.

13 of 13 people found the following review helpful:

5.0 out of 5 stars Awesome Resource..., January 15, 2008

By	Brian (Phoenix, AZ) - See all my reviews

This is - by far - the most valuable VBA tool I've purchased.

I generally have a hard time reading books about programming because they are either 1) way above my head, 2) don't provide "real-life" examples of when you would want to use the code, or 3) just plain boring. Not with this book...

It teaches you how to build tools - like progress indicators, advanced userforms, and general utilities. I've been able to take a little bit from each chapter and create stellar spreadsheet applications. This book has saved me hours... if I can't figure out how to write a block of code, I don't spend time searching Google - I go straight to the book.

Best Reason: it comes with a CD full of macro examples that mirror the chapter concepts. I was able to read the chapter, then go to the computer and try it out (with the code already written out for me). I picked up new concepts much faster than just reading it on my own.

Excellent for Excel 2003 or 2007.