Excel(r) 2007 Power Programming with VBA and over 360,000 other books are available for Amazon Kindle – Amazon’s new wireless reading device. Learn more

 

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

Have one to sell? Sell yours here
 
   
Express Checkout with PayPhrase
What's this? | Create PayPhrase
Sorry!
Excel 2007 Power Programming with VBA (Mr. Spreadsheet's Bookshelf)
 
 
Start reading Excel(r) 2007 Power Programming with VBA on your Kindle in under a minute.

Don’t have a Kindle? Get your Kindle here.
 
  

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

~ (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 (32 customer reviews)

List Price: $49.99
Price: $31.49 & this item ships for FREE with Super Saver Shipping. Details
You Save: $18.50 (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
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 Tuesday, November 10? Choose One-Day Shipping at checkout. Details
40 new from $28.63 24 used from $20.99

Formats

Amazon Price New from Used from
  Kindle Edition $25.19 -- --
  Hardcover -- -- --
  Paperback $31.49 $28.63 $20.99

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

Show availability and shipping details

  • This item: Excel 2007 Power Programming with VBA (Mr. Spreadsheet's Bookshelf) by John Walkenbach

    In Stock.
    Ships from and sold by Amazon.com.
    This item ships for FREE with Super Saver Shipping. Details

  • Excel 2007 Formulas (Mr. Spreadsheet's Bookshelf) by John Walkenbach

    In Stock.
    Ships from and sold by Amazon.com.
    This item ships for FREE with Super Saver Shipping. Details

  • Excel 2007 Bible by John Walkenbach

    In Stock.
    Ships from and sold by Amazon.com.
    This item ships for FREE with Super Saver Shipping. Details


Customers Who Bought This Item Also Bought

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

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

by Rob Bovey
4.8 out of 5 stars (32)  $37.79
Excel 2007 Bible

Excel 2007 Bible

by John Walkenbach
3.7 out of 5 stars (25)  $25.19
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 (7)  $26.39
Excel 2007 VBA Programming For Dummies (For Dummies (Computer/Tech))

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

by John Walkenbach
4.2 out of 5 stars (8)  $11.31
Excel 2007 VBA Programmer's Reference (Programmer to Programmer)

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

by John Green
3.5 out of 5 stars (8)  $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.


Product Details

  • Paperback: 1104 pages
  • Publisher: Wiley (April 16, 2007)
  • Language: English
  • ISBN-10: 0470044012
  • ISBN-13: 978-0470044018
  • Product Dimensions: 9.3 x 7.5 x 2.1 inches
  • Shipping Weight: 3.2 pounds (View shipping rates and policies)
  • Average Customer Review: 4.2 out of 5 stars  See all reviews (32 customer reviews)
  • Amazon.com Sales Rank: #6,728 in Books (See Bestsellers in Books)

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

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

More About the Author

John Walkenbach
Discover books, learn about writers, read author blogs, and more.

Visit Amazon's John Walkenbach Page

Inside This Book (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.
 
(9)

Your tags: Add your first tag
 

 

Customer Reviews

32 Reviews
5 star:
 (20)
4 star:
 (6)
3 star:
 (2)
2 star:
 (1)
1 star:
 (3)
 
 
 
 
 
Average Customer Review
4.2 out of 5 stars (32 customer reviews)
 
 
 
 
Share your thoughts with other customers:
Most Helpful Customer Reviews

 
42 of 44 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)      
Amazon Verified Purchase(What's this?)
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)



 
33 of 36 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
Amazon Verified Purchase(What's this?)
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)



 
17 of 17 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 Great VBA book!
This is a must have book for anyone wanting to learn VBA or improve their VBA programming.
Published 23 days ago by Chris

5.0 out of 5 stars This book done by a real spreadsheet expert. It's amazing!
Actually, I wanted to buy a book that's comprehensive that I could use it to know the secrets of VBA programming in Excel. Read more
Published 2 months ago by Hossam Eldin Khalefa

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 4 months 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 4 months 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 4 months 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 5 months 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 6 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 8 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 10 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 11 months ago by A. Parent

Only search this product's reviews



Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

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


Active discussions in related forums
Discussion Replies Latest Post
Textbooks for Kindle DX? 61 1 day ago
textbook scam 66 6 days ago
Amazon is a great place to buy textbooks! 35 18 days ago
Search Customer Discussions
Search all Amazon discussions
   




Product Information from the Amapedia Community

Beta (What's this?)


Look for Similar Items by Category


Look for Similar Items by Subject

 

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.


Your Recent History

 (What's this?)

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