- Paperback: 1116 pages
- Publisher: O'Reilly Media; 1 edition (5 May 2006)
- Language: English
- ISBN-10: 0596007663
- ISBN-13: 978-0596007669
- Product Dimensions: 17.8 x 6.1 x 23.3 cm
- Average Customer Review: 2.5 out of 5 stars See all reviews (2 customer reviews)
- Amazon Bestsellers Rank: 994,136 in Books (See Top 100 in Books)
- See Complete Table of Contents
Programming Excel with VBA and .NET Paperback – 5 May 2006
|New from||Used from|
- Choose from over 13,000 locations across the UK
- Prime members get unlimited deliveries at no additional cost
- Find your preferred location and add it to your address book
- Dispatch to this address when you check out
Customers Who Bought This Item Also Bought
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 e-mail address or mobile phone number.
Solve Real-World Problems with Excel
From the Publisher
Programming Excel isn't about adding new features as much as it's about combining existing features to solve particular problems. With Visual Basic for Applications (VBA), you can transform Excel into a task-specific piece of software that will quickly and precisely serve your needs. This single-source reference and how-to guide will teach you to use the complete range of Excel programming tasks to solve problems. Developers looking forward to .NET development will also find discussion of how the Excel object model works with .NET tools, including Visual Studio Tools for Office (VSTO).See all Product Description
Inside This Book(Learn More)
What Other Items Do Customers Buy After Viewing This Item?
Top Customer Reviews
Let me say that as an all round reference for Excel there is plenty of information in here and if you do not have a bookshelf full of Excel VBA books then this would probably be a good purchase. The format is very readable and there is a wealth of information for a 'newbie' Excel VBA programmer. Although, I think that allot of the details this book covers have already been offered from Bovey, ET all in the 'Professional Excel Development' book published by Addison Wesley.
The issue I have is that the title of this book is very misleading. The title is 'programming Excel with VBA & .NET'; I do not think that the content of this book warrants this title. I was very disappointed to see that of the 1016 pages in this book (excluding appendixes) there are only 37 pages dedicated to .net, I wish I had investigated further before my purchase. The uses for the .Net platform with regard to Excel appear very limited and since looking at the options in this book (which are very few) I am tempted to say that the most reliable method of robust system programming against the Excel Object model is probably C++. As an intro to this I would recommend ditching the VB.Net idea and heading for 'Financial Applications Using Excel Add-in Development in C/C++, 2nd Edition' by Steve Dalton which is an excellent book with a better approach for extending addins etc for Excel.
Excel VBA and .NET? Don't bother
Excel VBA and some .NET - as a newbie reference? Maybe.....
The title is misleading however: out of the 1000 pages, only 40 are devoted to .NET !!!
Most Helpful Customer Reviews on Amazon.com (beta)
I have read other books that devote more space to and explain better the use of Ranges in VBA code; "pictures are worth a thousand words". If you cannot assimilate this aspect of VBA programming with Excel then you will struggle. Because of the recursive nature of Range references in Excel it can be a difficult concept to understand. I know personally that when I got the hang of that and how to use relative referencing with the R1C1 notation and to use the Cell object my productivity went up tremendously, and my frustration level dropped accordingly. Excel is probably the most difficult and complex application of the Office products when it comes to the Object Model and accordingly programming in VBA. On balance I would have no hesitation in recommending this book as part of your Excel VBA programming arsenal. Typically no one book can give you all of the insight that you need. Accordingly I feel comfortable in giving it 5 stars.
A mere 30 pages is devoted to .NET. Most of this is simply how to fire up Visual Studio and create a project. Worthless, really. I'm betting that the publisher made the decision to add ".NET" to the title since that was a sexy buzzword back in '03. I'm subtracting a single star for this little piece of marketing deception. In summary, this book is terrific for learning Excel VBA (and general programming principles), but is no good for learning how to marry Excel to .NET.
The "comprehensive" half of my review title comes with the packed 1100 pages. All the programming basics, all the programmable objects, all the usable features are covered. In addition, the book covers extending Excel with add-ins and dealing with security.
My own interest in programming Excel objects is related to my job as a GUI interface developer for browser-based applications. As more information and functionality goes to the Web, the convenience of taking HTML data displays and exporting them to Excel is finding an expanding and demanding market. I was somewhat disappointed that the book did not approach more topics from the perspective of this modern trend.
A friend preparing to teach Excel VBA next fall grabbed the book from my desk and had a look. She was certain "Excel with VBA & .NET" would be an excellent platform and reference for that class. That high recommendation certainly trumps my quibble about not having more material on browser implementations.
...if you need the support documentation, you now need to go to the OREILLY site directly and download the files from them:
(I am maintaining the two-star review, so that people won't lose it in the otherwise glowing reviews)
Look for similar items by category
- Books > Computing & Internet > Computer Science > Information Systems
- Books > Computing & Internet > Digital Lifestyle > Online Shopping > Amazon
- Books > Computing & Internet > Microsoft Windows > Applications > Excel
- Books > Computing & Internet > Microsoft Windows > Operating Systems
- Books > Computing & Internet > Programming > Languages
- Books > Computing & Internet > Programming > Microsoft Windows
- Books > Computing & Internet > Software & Graphics > Business & Home Office > Spreadsheets