Join Amazon Prime and ship Two-Day for free and Overnight for $3.99. Already a member? Sign in.

 

or
Sign in to turn on 1-Click ordering.
 
   
More Buying Choices
86 used & new from $18.42

Have one to sell? Sell yours here
 
   
Excel 2007 Power Programming with VBA (Mr. Spreadsheet's Bookshelf)
 
 
Tell the Publisher!
I’d like to read this book on Kindle

Don’t have a Kindle? Get yours here.
 
  

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...)
4.2 out of 5 stars See all reviews (30 customer reviews)

List Price: $49.99
Price: $31.49 & this item ships for FREE with Super Saver Shipping. Details
You Save: $18.50 (37%)
Upgrade this book for $9.99 more, and you can read, search, and annotate every page online. See details
In Stock.
Ships from and sold by Amazon.com. Gift-wrap available.

Want it delivered Monday, July 13? Choose One-Day Shipping at checkout. Details
53 new from $18.42 33 used from $18.43
Also Available in: List Price: Our Price: Other Offers:
Hardcover Order it used!

Frequently Bought Together

Excel 2007 Power Programming with VBA (Mr. Spreadsheet's Bookshelf) + Excel 2007 Formulas (Mr. Spreadsheet's Bookshelf) + Excel 2007 Bible
Price For All Three: $85.02

Customers Who Bought This Item Also Bought

Excel 2007 Bible

Excel 2007 Bible

by John Walkenbach
3.8 out of 5 stars (22)  $25.19
Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel, VBA, and .NET (2nd Edition) (Addison-Wesley Microsoft Technology Series)

Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel, VBA, and .NET (2nd Edition) (Addison-Wesley Microsoft Technology Series)

by Rob Bovey
4.8 out of 5 stars (28)  $37.79
Excel 2007 VBA Programming For Dummies (For Dummies (Computer/Tech))

Excel 2007 VBA Programming For Dummies (For Dummies (Computer/Tech))

by John Walkenbach
4.0 out of 5 stars (6)  $16.49
Excel 2007 VBA Programmer's Reference (Programmer to Programmer)

Excel 2007 VBA Programmer's Reference (Programmer to Programmer)

by John Green
3.7 out of 5 stars (7)  $26.39
John Walkenbach's Favorite Excel 2007 Tips & Tricks (Mr. Spreadsheet's Bookshelf)

John Walkenbach's Favorite Excel 2007 Tips & Tricks (Mr. Spreadsheet's Bookshelf)

by John Walkenbach
4.7 out of 5 stars (6)  $26.39
Explore similar items

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

Inside This Book (learn more)


Books on Related Topics (learn more)
 
 

What Do Customers Ultimately Buy After Viewing This Item?


Tags Customers Associate with This Product

 (What's this?)
Click on a tag to find related items, discussions, and people.
Check the boxes next to the tags you consider relevant or enter your own tags in the field below.
(8)

Your tags: Add your first tag
 
Help others find this product — tag it for Amazon search
No one has tagged this product for Amazon search yet. Why not be the first to suggest a search for which it should appear?

Sell a Digital Version of This Book in the Kindle Store

If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store. Learn more

 

Customer Reviews

30 Reviews
5 star:
 (18)
4 star:
 (6)
3 star:
 (2)
2 star:
 (1)
1 star:
 (3)
 
 
 
 
 
Average Customer Review
4.2 out of 5 stars (30 customer reviews)
 
 
 
 
Share your thoughts with other customers:
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.
Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)



 
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
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.
Comment Comments (2) | Permalink | Was this review helpful to you? Yes No (Report this)



 
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.
Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)


Share your thoughts with other customers: Create your own review
 
 
 
Most Recent Customer Reviews

5.0 out of 5 stars Indispensable Excel/VBA 2007 Resource
I have projects that need potential productivity boosts that can only be achieve in Excel using VBA. Read more
Published 17 hours ago by James Gunn

5.0 out of 5 stars Power Programming with VBA
I ordered the book on regular mail to be delivered in Brazil.Time was not an issue to me. I received the book 3 weeks after I placed the order. Read more
Published 3 days ago by Jairo D. Jordan

5.0 out of 5 stars great book great service
We received this book in good time, didn't have any problems at all. Great price also.
Published 13 days ago by M. Sagers

4.0 out of 5 stars good. reference book
Great book, I was looking to increase my excel skills, and this book fit the bill.
Published 1 month ago by L. J. Harmon

1.0 out of 5 stars I didn't get it yet (after 2 month )
Amazon charge me twice and already took the mouney, and still i have no book and i realy dont know what to do with that case..
Published 2 months ago by Aviad Har-tal

3.0 out of 5 stars Walkenbach Excel Power Programming
VBA programming in Excel defies easy documentation is the style that C++ or Pascal would lend itself. Read more
Published 4 months ago by Edward C. Cannon

4.0 out of 5 stars Really enjoyed book but
THe books by J-Walk are really helpful. But I was disappointed . Not only did this book not come with the e-book but the cd was completely missing.
Published 6 months ago by George E. Robillard

5.0 out of 5 stars Best of category
This is a best of breed book on using VBA for Excel 2007. Walkenbach is a clear and accessible writer. Read more
Published 7 months ago by A. Parent

4.0 out of 5 stars Excel VBA
The book seems to be what I need to learn VBA for the projects that I have to complete. I have the Excel Bible, also by John Walkenbach. Read more
Published 7 months ago by Bonnie Poertner

5.0 out of 5 stars It's by John Walkenbach... what else do you need to know...
Walkenbach hasn't lost his touch. Belongs on the desk of anyone using VBA with Excel 2007 .
Published 9 months ago by Alan C.

Only search this product's reviews



Customer Discussions

 Beta (What's this?)
New! See all customer communities, and bookmark your communities to keep track of them.
This product's forum (0 discussions)
  Discussion Replies Latest Post
  No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
  [Cancel]


Active discussions in related forums
  Discussion Replies Latest Post
C# or Java? 32 3 days ago
   


Product Information from the Amapedia Community

Beta (What's this?)



Look for Similar Items by Category


Turn On the Savings

Home Improvement Value Center
Shop for bathroom faucets in the Home Improvement Value Center, where the savings can flow as much as 50% off brand-name products.

Shop the Value Center

 

Best Books of 2008

Best of 2008
Find our top 100 editors' picks as well as customers' favorites in dozens of categories in our Best Books of 2008 Store.
 
Shop for In-Sink-Erators
Instant Hot Water at Your FingertipsUpdate the functionality of your sink with a unique In-Sink-Erator hot water dispenser.
 

Fimco Industries

Shop for Fimco products
Fimco manufactures sprayers and agricultural equipment ideal for lawn and garden protection.

Shop all Fimco products

 

 

Feedback

If you need help or have a question for Customer Service, contact us.
 Would you like to update product info or give feedback on images?
Is there any other feedback you would like to provide?

Your comments can help make our site better for everyone.


Where's My Stuff?

Shipping & Returns

Need Help?

Your Recent History

  (What's this?)
You have no recently viewed items or searches.

After viewing product detail pages or search results, look here to find an easy way to navigate back to pages you are interested in.

Look to the right column to find helpful suggestions for your shopping session.

Continue shopping: Top Sellers
Glenn Beck's Common Sense
Glenn Beck's Common Sense
Darkfever
Darkfever by Karen Marie Moning
The Adventures of Sherlock Holmes
The Adventures of Sherlock Holmes by Arthur Conan, Sir, 1859-1930 Doyle

Conditions of Use | Privacy Notice © 1996-2009, Amazon.com, Inc. or its affiliates