• RRP: £36.50
  • You Save: £7.30 (20%)
FREE Delivery in the UK.
Only 2 left in stock (more on the way).
Dispatched from and sold by Amazon. Gift-wrap available.
Programming Excel with VB... has been added to your Basket
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See all 3 images

Programming Excel with VBA and .NET Paperback – 5 May 2006

2.5 out of 5 stars 2 customer reviews

See all formats and editions Hide other formats and editions
Amazon Price
New from Used from
Kindle Edition
"Please retry"
"Please retry"
£20.57 £5.84
Note: This item is eligible for click and collect. Details
Pick up your parcel at a time and place that suits you.
  • Choose from over 13,000 locations across the UK
  • Prime members get unlimited deliveries at no additional cost
How to order to an Amazon Pickup Location?
  1. Find your preferred location and add it to your address book
  2. Dispatch to this address when you check out
Learn more
£29.20 FREE Delivery in the UK. Only 2 left in stock (more on the way). Dispatched from and sold by Amazon. Gift-wrap available.

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.

  • Apple
  • Android
  • Windows Phone

To get the free app, enter your e-mail address or mobile phone number.

Product details

  • 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

Product Description

Book Description

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)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

Customer Reviews

2.5 out of 5 stars
5 star
4 star
3 star
2 star
1 star
See both customer reviews
Share your thoughts with other customers

Top Customer Reviews

Format: Paperback
I have been working with Excel VBA development for a number of years now and have a wide range of books covering the subject; some of these are good and some not so good. I bought this particular book as I wanted to know more about integrating the new .Net platform and the Excel Object model. My aim was to move up from the VB6 addins etc that I have been building in the past and make the transition to .NET.

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.....
1 Comment 8 of 8 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
This book is a comprehensive reference on Excel VBA. Beginners can also use it as a textbook. It is not the best written programming book that I have seen, but it does the job.
The title is misleading however: out of the 1000 pages, only 40 are devoted to .NET !!!
Comment 1 of 1 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse

Most Helpful Customer Reviews on Amazon.com (beta)

Amazon.com: HASH(0x9e6c9240) out of 5 stars 10 reviews
38 of 40 people found the following review helpful
HASH(0x9edfec84) out of 5 stars Great reference book 26 Jun. 2006
By Graham Jones - Published on Amazon.com
Format: Paperback
"Programming Excel with VBA & .NET" is certainly a very 'weighty' tome. At around 1100 pages you certainly get a lot of paper for your money! However, do you get value for your money? I have yet to read a book on this topic which is more comprehensive in its coverage in terms of the description of the Object Model and the properties and methods, in many cases complete with useful examples. So in that regard it is an excellent reference. The benefit of the author being part of the Microsoft OLE Automation team when VB was added to Excel is very clear. The book also covers VBA itself in good depth. However, I feel that much of this could have been usefully relegated to a reference Appendix. If you are buying this book to learn VBA as such then there are many other excellent choices. The value in this book is in the application of VBA to Excel. You should not consider this book unless you are already very comfortable with VBA. If you are only just learning VBA but try to go on to read the rest of the book, you might find it hard going.

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.


Graham Jones
24 of 24 people found the following review helpful
HASH(0x9edfecd8) out of 5 stars Great book, but where's the .NET? 7 Oct. 2008
By shancarrick - Published on Amazon.com
Format: Paperback
This is a fantastic book for learning VBA programming in Excel. The first 70 pages are devoted to programming basics (variables, conditional statements, objects, modules and procedures, etc.) Most of the rest of the book is devoted to glorious Excel tasks and objects. Really, this is quality material.

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.
21 of 22 people found the following review helpful
HASH(0x9ee0112c) out of 5 stars Comprehensive and Authoritative 7 Jun. 2006
By Brett Merkey - Published on Amazon.com
Format: Paperback
When you attempt to get into a new area of coding, it is best to have an authoritative reference. Confidence in your source really helps in getting through the inevitable rough spots. "Excel with VBA & .NET" seems to fill the bill. It certainly does not hurt to know that the author was on the Microsoft OLE Automation team when VB was added to Excel.

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.
3 of 3 people found the following review helpful
HASH(0x9ee014f8) out of 5 stars Good Book 12 Mar. 2009
By Harry - Published on Amazon.com
Format: Paperback Verified Purchase
This is a really good book. I think it's geared for people who are somewhere in between beginner programmer and intermediate programmer. If you're a true beginner, I think the Excel VBA for Dummies book is a better choice. If you're trying to get a bit more advanced, this book is probably right for you.
1 of 1 people found the following review helpful
HASH(0x9ee014a4) out of 5 stars Support Documentation no longer available. 20 Jun. 2015
By Algor Langeaux - Published on Amazon.com
Format: Paperback Verified Purchase
Sample files are not included with the book, and the domain that we were to download them from now redirects to the "sharepointworkshop.com" front end with no available downloads for this legacy product in sight. If you were looking to be able to go through this with the practice files, you are SOL, unless they get a clue and continue to support legacy users.

...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)
Were these reviews helpful? Let us know