Excel 2010 Power Programming with VBA (Mr. Spreadsheet's Bookshelf) (英語) ペーパーバック – 2010/5/10
Kindle 端末は必要ありません。無料 Kindle アプリのいずれかをダウンロードすると、スマートフォン、タブレットPCで Kindle 本をお読みいただけます。
All the methods and tools you need to successfully program with Excel
John Walkenbach's name is synonymous with excellence in computer books that decipher complex technical topics. With this comprehensive guide, "Mr. Spreadsheet" shows you how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf.
Featuring a complete introduction to Visual Basic for Applications and fully updated for the new features of Excel 2010, this essential reference includes an analysis of Excel application development and is packed with procedures, tips, and ideas for expanding Excel’s capabilities with VBA.
- Offers an analysis of Excel application development and a complete introduction to Visual Basic for Applications (VBA)
- Features invaluable advice from "Mr. Spreadsheet" himself (bestselling author John Walkenbach), who demonstrates all the techniques you need to create large and small Excel applications
- Provides tips, tricks, and techniques for expanding Excel's capabilities with VBA that you won’t find anywhere else
- Includes a CD with templates and worksheets from the book
This power-user's guide is packed with procedures, tips, and ideas for expanding Excel's capabilities with VBA.
Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
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.
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.
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.
help if you've spent some time reading other books on VBA, and Excel for that matter, and then you may be better able to judge
for yourself how he, more often than not, better explains the topic in clear and concise language. The reference has a profuse distribution of examples of VBA code. The text has 31 Chapters, and I am just into Chapter 9 at this time, but I am reading the
text, word for word, line for line, page for page, and performing some of the examples for myself. However, I have most, if not
all of Walkenbach's references on Excel and VBA for I personally feel these are great "go-to" references when you need a VBA
or Excel question answered (I currently have 7 of his books but may have missed some I have at work, including this same text
in the 2007 version). In a few instances, however, I have had to Google. The Appendix is thorough, and the Index is quite
extensive and covers most topics that I could think of, at least at this moment in time. There may be a few not covered, but one
must realize no text is perfect. I probably have 20+ reference texts on VBA. I rank Walkenbach at the top for his overall ability to better explain things, and thus allow me, at least, to "connect the dots." If you want an excellent first or fifth reference on VBA and
have Office 2010, get this text!