- 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: 81 customer reviews
- Amazon Best Sellers Rank: #666,952 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.
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
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
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.
- 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.
Most recent customer reviews
I program for a living, and always get requests from users to automate their spreadsheets.Read more