Excel 2010 Power Programming with VBA Author: John Walkenbach | Language: English | ISBN:
B005ZIPQK6 | Format: EPUB
Excel 2010 Power Programming with VBA Description
All the methods and tools you need to successfully program with ExcelJohn 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.
- File Size: 7048 KB
- Print Length: 1080 pages
- Publisher: Wiley; 1 edition (April 15, 2010)
- Sold by: Amazon Digital Services, Inc.
- Language: English
- ASIN: B005ZIPQK6
- Text-to-Speech: Enabled
X-Ray:
- Lending: Enabled
- Amazon Best Sellers Rank: #122,140 Paid in Kindle Store (See Top 100 Paid in Kindle Store)
- #26
in Books > Computers & Technology > Microsoft > Development > VBA - #66
in Books > Computers & Technology > Microsoft > Development > Visual Basic
- #26
in Books > Computers & Technology > Microsoft > Development > VBA - #66
in Books > Computers & Technology > Microsoft > Development > Visual Basic
While everyone's starting to learn cooler hipper languages, the reality is that VBA in excel is still pretty darn useful.
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.
By 1000Books
I find the book very informative and useful and I feel cheated on
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.
By Sigthor
Excel 2010 Power Programming with VBA Preview
Link
Please Wait...