- Paperback: 1080 pages
- Publisher: Wiley; 1 edition (May 10, 2010)
- Language: English
- ISBN-10: 0470475358
- ISBN-13: 978-0470475355
- Product Dimensions: 7.3 x 2.1 x 9.2 inches
- Shipping Weight: 3.6 pounds (View shipping rates and policies)
- Average Customer Review: 4.2 out of 5 stars See all reviews (172 customer reviews)
- Amazon Best Sellers Rank: #59,590 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 2010 Power Programming with VBA 1st Edition
Use the Amazon App to scan ISBNs and compare prices.
Featured design resources sponsored by O'Reilly Media. See more
Frequently bought together
Customers who bought this item also bought
From the Back Cover
Get more from Excel—learn to extend it with VBA
Learn to use Visual Basic for Applications (VBA), and you can expand the already awesome power of Excel 2010. John Walkenbach, aka Mr. Spreadsheet, shows you how to do it in this easy-to-follow guide.
If you're already an experienced Excel user, this book will make you an Excel master. You'll learn a new approach to Excel and the steps involved in developing a new spreadsheet application. You'll also discover how to develop VBA subroutines and functions, use advanced programming techniques, and more. And if you're switching to Excel 2010 from an earlier version, there's a section to get you up to speed on the new features.
No one can teach you more about Excel than Mr. Spreadsheet.
Let Mr. Spreadsheet show you how to:
Create powerful Excel apps with VBA
Develop user-friendly dialog boxes
Enhance Excel with custom worksheet functions
Write event-driven VBA code
More than 300 files used as examples in the book
Searchable PDF of the book
See Appendix D for 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 50-plus books include John Walkenbach's Favorite Excel 2010 Tips & Tricks, Excel 2010 Formulas, and the bestselling Excel Bible, all published by Wiley. Visit his popular Spreadsheet Page at spreadsheetpage.com.
Learn more about the NewChart Event, a feature introduced in Excel 2010 [PDF].
If you are a seller for this product, would you like to suggest updates through seller support?
Top Customer Reviews
If you have absolutely no experience then VBA for dummies is still - to me - one of the better places to start. The book is not as big and intimidating. However, after you've already written a few programs, this book is fantastic. Great step by step instructions. Lots of examples. Advanced sections are great. It will take me some time before this all becomes old hat for me.
If you were looking for something that uses VBA to link to other Microsoft applications. You should be good with this book. It goes into detail on how to interface with outlook, deal with sending emails, interface with Word or PowerPoint.
If you need to learn how to interface with databases, this is not the best choice. But there is no reason to believe it would be in the title or table of contents, so you really can't complain.
Will it replace the all mighty google. No, but as a supplement, it is excellent and a bit more structured. The explanations are far better than what you'd find on-line. There are tons of random helpful tips and history that - if you're nerdy enough to read the whole book rather than just use the table of contents and index to get to the sections you need - are pretty darn wonderful.
Oh, and for people who can't stand the upgrades in the new version of Excel, the author explains that stuff too. One reason to get the newer vs the older version.
I sadly bought the Kindle version and I feel ripped off, First I pay 4 dollars more for the Kindle version even if that meant me not getting the CD or other side products. I could live with that, at least I got the book right....
But no, the examples in this book are useless as it is not possible to zoom the images with Kindle and most formuals that Spreadsheet goes over are based on those images.
I had before bought the book "Excel The missing Manual" and that was great on Kindle and it was even cheaper for Kindle,
but adding 4 dollars for Kindle version without any side products and horrible quality is a rip off, and Mr. Spreadseet and Amazon should really do something to fix this. Its amazing disrespect to customers. I cant see my self buy a book by Mr. Spreadsheet again or even Amazon just because of this incident, I'll stick to other authors that at least have the decency to not publish books for Kindle version if they cant provide the same quality as the book.
It is incredibly frustrating and i feel so ripped off, you can not see this flaw in the preview so I feel cheated on.
Sad as the book is so good.
WOW! John Walkenbach does a great job of starting at the beginning, giving a very interesting spreadsheet background, and then quickly and concisely plunging you into the VBA world. I have also picked up a lot of non-VBA great Excel tips that I have started using.
Keep in mind, this book still isn't for the timid. It is serious learning and you have to be prepared to learn quick. But, I feel the book does a great job of teaching with just the right amount of detail. It also helps if you think very logical and sequential. If you can't organize your thoughts, you won't be able to program very well.
having the book available on my iPad was great, but I really wish I could get the code on the