Excel 2007 Power Programming with VBA 1st Edition
Use the Amazon App to scan ISBNs and compare prices.
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.
From the Back Cover
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
- Publisher : Wiley; 1st edition (April 16, 2007)
- Language : English
- Paperback : 1104 pages
- ISBN-10 : 0470044012
- ISBN-13 : 978-0470044018
- Item Weight : 3.27 pounds
- Dimensions : 7.42 x 2 x 9.3 inches
- Best Sellers Rank: #1,726,537 in Books (See Top 100 in Books)
- Customer Reviews:
Top reviews from the United States
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.
While the text remains the same, the main problem with the Kindle version of this book is the formatting. Reading is is a serious chore. Almost every paragraph is broken up at the most inconvenient places, at the main culprit stems from the code examples typed in monospace font. I don't know if it has something to do with my readers, whether it be the iOS Kindle app or the Cloud Reader.
Since this is an obsolete book, I am hoping that the next edition will have this problem corrected.
Top reviews from other countries
One teeny criticism is that the author can tend to be a bit of a show off. For example, he demonstrates how to improve on code recorded from the macro recorder (which is fine), but then go on to show how a really clever programmer (him) could write the code from scratch to make it tighter still, which is perhaps not that necessary.
My code is still probably not the optimum solution to the problem, but it gets the job done efficiently thanks to what I've learned from this book.
I am a mature student and know that I will need to know as much as possible about VBA as it appears in my studies next year. So, I have around 5 months to get to grips with this and other diciplines. A further review may be required in Sept when I have had the chance to test my new knowledge which has been gleaned from this book.
Very interesting I use it very day and have learnt a lot, there is more information then the Vbe programming for dummies book
Which I brought also.