Excel 2007 Power Programming with VBA and over one million other books are available for Amazon Kindle. Learn more

Sorry, this item is not available in
Image not available for
Color:
Image not available

To view this video download Flash Player

 


or
Sign in to turn on 1-Click ordering
Sell Us Your Item
For a $4.01 Gift Card
Trade in
More Buying Choices
Have one to sell? Sell yours here
Start reading Excel 2007 Power Programming with VBA on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Excel 2007 Power Programming with VBA [Paperback]

by John Walkenbach
4.2 out of 5 stars  See all reviews (66 customer reviews)

List Price: $49.99
Price: $31.48 & FREE Shipping on orders over $35. Details
You Save: $18.51 (37%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Only 16 left in stock (more on the way).
Ships from and sold by Amazon.com. Gift-wrap available.
Want it tomorrow, April 25? Choose One-Day Shipping at checkout. Details
Free Two-Day Shipping for College Students with Amazon Student

Formats

Amazon Price New from Used from
Kindle Edition $28.49  
Hardcover --  
Paperback $31.48  
Unknown Binding --  
Sell Us Your Books
Get up to 80% back when you sell us your books, even if you didn't buy them at Amazon. Learn more
There is a newer edition of this item:
Excel 2013 Power Programming with VBA Excel 2013 Power Programming with VBA 4.4 out of 5 stars (17)
$28.99
In Stock.

Book Description

April 16, 2007 0470044012 978-0470044018 1
  • 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.


Frequently Bought Together

Excel 2007 Power Programming with VBA + Excel 2007 Bible + Excel 2007 Formulas
Price for all three: $83.68

Buy the selected items together
  • Excel 2007 Bible $23.49
  • Excel 2007 Formulas $28.71


Editorial Reviews

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.

About the Author

John Walkenbach, arguably the foremost authority on Excel, has written hundreds of articles and created the award-winning Power Utility Pak. His 40-plus books include Excel 2007 Bible, Excel 2007 Formulas, and John Walkenbach's Favorite Excel Tips & Tricks, all published by Wiley. Visit his popular Spreadsheet Page at www.j-walk.com/ss.

Product Details

  • Paperback: 1104 pages
  • Publisher: Wiley; 1 edition (April 16, 2007)
  • Language: English
  • ISBN-10: 0470044012
  • ISBN-13: 978-0470044018
  • Product Dimensions: 9.2 x 7.3 x 2 inches
  • Shipping Weight: 3.1 pounds (View shipping rates and policies)
  • Average Customer Review: 4.2 out of 5 stars  See all reviews (66 customer reviews)
  • Amazon Best Sellers Rank: #127,794 in Books (See Top 100 in Books)

More About the Author

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

John lives in Tucson, Arizona. He also plays the banjo - but don't let that prevent you from buying his books.

Customer Reviews

Most Helpful Customer Reviews
100 of 106 people found the following review helpful
5.0 out of 5 stars 5 stars in spite of the misleading title November 28, 2007
Format:Paperback|Verified Purchase
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 software development tool your company will ever need. In short, and I say this with the greatest admiration and respect, 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.
Was this review helpful to you?
43 of 45 people found the following review helpful
5.0 out of 5 stars Awesome Resource... January 15, 2008
Format:Paperback
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.
Comment | 
Was this review helpful to you?
23 of 24 people found the following review helpful
5.0 out of 5 stars Very good reference for VBA Beginners March 6, 2008
By Eric B
Format:Paperback
I have this book for more than two months now and I found it very useful especially on my first VBA project. I have a weekly report and I used to do this manually and often get errors because I have to cross reference values in one big spreadsheet with multiple tabs. Not until I got this book and read the basics and go to specific chapters where I need help. I felt so accomplished after I finished the whole macro. What took me 30 minutes to do manual referencing and typing now only takes less than two minutes including sending it through email. This book is very easy to understand especially for those who know Excel and would like to expand their skills in VBA. Mr Spreadsheet has provided good example files to help us better understand VBA. His approach is basic enough for those who doesn't have any experience in creating macros. By the way if your CD doesn't have the source files or example file go to [...] and select "All Wiley Products" or call Technical Support. Type your request for the e-source files and they will get back to you really fast with a link of the FTP site for the files. Don't bother to call customer support because they will try to sell you the e-book even though you already have the book. It might be a hassle but its all worth it.
Comment | 
Was this review helpful to you?
12 of 14 people found the following review helpful
3.0 out of 5 stars Nice information September 19, 2008
By J
Format:Paperback
I am a novice to VBA and this is the first book I have purchased on the subject. It has alot of useful information. However, it skims so briefly over many topics. If you have a good grasp of VBA and what it can do, I think this is a nice reference. For someone like me, who is just starting, there is probably something better out there.
Was this review helpful to you?
8 of 9 people found the following review helpful
4.0 out of 5 stars Kindle Version -- How to Get the CD February 3, 2011
Format:Kindle Edition|Verified Purchase
I saw a review or two below complaining about not getting the accompanying CD with their purchase....DUH!! Not gonna happen when you buy e-books!! Typically, the publisher will have the material somewhere online. The trick is finding it. Usually I have found a URL somewhere in the book that has a download link....well, Wiley is making it a bit more difficult for us. Here's where to go and what to do when you get there:

- Go to the Wiley dot custhelp dot com website, and click on the "ask a question tab.

- Fill out the information on the form, and tell them that you bought the book from Amazon in Kindle format, and that you want the WHOLE CD content.

- Save yourself some time (UNLIKE I did....) and make an electronic copy of your Amazon receipt (i.e. PDF or something they can see), and attach it to the message...there's a place to do so at the bottom of the window.

They responded to me within an hour. At first, they wanted to just give me a link to the PDF version of the book, but one response to that (and with a different Wiley rep) telling them I needed the whole CD solved that. They will snail-mail you a copy of the CD ASAP. Okay, it's not quite as nice as being able to just download the content online, which is why I gave this FOUR stars instead of FIVE---it's the "hassle factor" that cost them a star.

Otherwise....GREAT book. This book is much more than a VBA primer. It definitly does assume a reasonable amount of Excel experience, but let's face it -- should you really be trying to develop Excel apps if you don't already have some knowledge of the product? Walkenbach goes through a bunch of stuff he thinks you should know about early on in the book, without going into too much detail...
Read more ›
Was this review helpful to you?
Most Recent Customer Reviews
4.0 out of 5 stars Pretty good read.
This book is for the beginner programmer. It still is a good read and could help the intermedate skilled programmer.
Published 3 days ago by Dan Kohnen
3.0 out of 5 stars I am probably reading it wrong
I purchased this book long time ago and finally decided to go reading it. At half the book, most of the reading is becoming quite painful. Read more
Published 1 month ago by bolo591
3.0 out of 5 stars Writing in book was faded and could not be read easily
Generally the book is a very good reference book for those who want to do programming in VBA Excel. My main problem with this book was that you could hardly read what was on the... Read more
Published 4 months ago by R. Ferguson
4.0 out of 5 stars Good Book, easy transition from 2000
I have been away from Excel programming for too long. This book is somewhat similar to the Excel 2000 book that I rely heavily on.
That makes the transition MUCH easier. Read more
Published 7 months ago by jay8000
4.0 out of 5 stars useful book
This book has been a helpful resource and it has become a shared resource for use by everyone in our office.
Published 10 months ago by Paul S
5.0 out of 5 stars Walkenback is the best source I use for Excel.
Has generally clear explanations and useful examples. I also have his Excel 2000 version and recently bought his 2010 version. Read more
Published 11 months ago by Tony Cooley
1.0 out of 5 stars i hate it
author goes all over the place
similar to the other books -- it is a duplicate

author goes all over the place
similar to the other books -- it is a duplicate
Published 13 months ago by Linda P. Dowdell
5.0 out of 5 stars Great book
Excellent book. Suited for first time VBA users. Seems unfriendly because of the length, but covers basic and intermediate topics in a very comprehensive manner. Read more
Published 13 months ago by Oliver Montas
4.0 out of 5 stars Needed for work
It did its job. I haven't done much in Excel VBA in a long time. And my work computer is 2007 version. Read more
Published 13 months ago by BR
5.0 out of 5 stars Excellant book
It had been a looong time since I had written any Excel macros and needed some help. With this book I had my softeware written in one day.
Published 14 months ago by Robert C Taubert
Search Customer Reviews
Only search this product's reviews
ARRAY(0x9f3d0c18)



What Other Items Do Customers Buy After Viewing This Item?


Forums

Topic From this Discussion
The companion CD Be the first to reply
Have something you'd like to share about this product?
Start a new discussion
Topic:
First post:
Prompts for sign-in
 


Search Customer Discussions
Search all Amazon discussions


Look for Similar Items by Category