- Paperback: 1104 pages
- Publisher: Wiley; 1 edition (April 16, 2007)
- Language: English
- ISBN-10: 0470044012
- ISBN-13: 978-0470044018
- Product Dimensions: 7.4 x 2 x 9.3 inches
- Shipping Weight: 3.1 pounds (View shipping rates and policies)
- Average Customer Review: 82 customer reviews
- Amazon Best Sellers Rank: #362,547 in Books (See Top 100 in Books)
Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
Excel 2007 Power Programming with VBA 1st Edition
Use the Amazon App to scan ISBNs and compare prices.
Fulfillment by Amazon (FBA) is a service we offer sellers that lets them store their products in Amazon's fulfillment centers, and we directly pack, ship, and provide customer service for these products. Something we hope you'll especially enjoy: FBA items qualify for FREE Shipping and Amazon Prime.
If you're a seller, Fulfillment by Amazon can help you increase your sales. We invite you to learn more about Fulfillment by Amazon .
The Amazon Book Review
Author interviews, book reviews, editors picks, and more. Read it now
Frequently bought together
Customers who bought this item also bought
Customers who viewed this item also viewed
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
- 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.
Top customer reviews
There was a problem filtering reviews right now. Please try again later.
The main reason I bought a Kindle was so that I wouldn't have to lug a bunch of heavy books around for reference. Unfortunately, we're just not there yet.
I'm only 20% through so far so I can't rate the content at this point--will do it later.
However, something really needs to be said for the required CD and the poor formatting of the code in the Kindle release. With the shift towards technology and digital downloads, Authors' websites really need to reflect this. If a book requires a CD, then it should be easy enough to locate that content on their site. Otherwise, why offer a digital edition?
In the defence of the lacking CD, the content can be located on the site, but it's a disaster to try and find it. First off, the site in the book is outdated and it takes you to the old site. Luckily there is a forwarding link that takes you to a site that is not very well organised. Tidbits of code are scattered about without any reference as to which book it may be in relation to. This makes some of it difficult to find. Other tidbits that the book refers to on the CD either don't appear on the website, or they're difficult to find. I've yet to find them.
In addition to that, the formatting needs work. The book, itself, is well-written. However, when it comes to the code, parts of it are cut off and it's difficult to get a full view of it. Landscape helps a bit, but the code is still cut off on the normal-sized Kindle. This needs to be addressed because it's useless to learn from at this point. Please fix this.
*iPad owners and large-screen readers may not notice the formatting issues since all's well on my iPad--the code is fine. The issue appears to exist with the regular (common) sized screens.
- 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...the responsibility to get the additional knowledge, therefore rests upon the reader. He then discusses the planning phase, which is not unlike the planning phase of any project, then gives a good foundation of knowledge in the important Excel and VBA skills required to do a good job of development. Great book...highly recommended, even in Kindle format, and with the associated hassle getting the CD.