Programming Excel with VBA and .NET (Paperback)

Customers buy this book with Excel Hacks: Tips & Tools for Streamlining Your Spreadsheets by David Hawley

+

Price For Both: £45.84

Show availability and shipping details

• This item: Programming Excel with VBA and .NET by Jeff Webb

  In stock.
  Dispatched from and sold by Amazon.co.uk.
  This item Delivered FREE in the UK with Super Saver Delivery. See details and conditions
  

• Excel Hacks: Tips & Tools for Streamlining Your Spreadsheets by David Hawley

  In stock.
  Dispatched from and sold by Amazon.co.uk.
  This item Delivered FREE in the UK with Super Saver Delivery. See details and conditions
  

Excel Hacks: Tips & Tools for Streamlining Your Spreadsheets by David Hawley £16.09

Excel Scientific and Engineering Cookbook (Cookbooks (O'Reilly)) by David Bourg £23.99

Writing Excel Macros with VBA by Steven Roman 4.3 out of 5 stars (3)  £18.89

Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel, VBA, and .NET: The Definitive Guide to ... and VBA (Addison-Wesley Microsoft Technology) by Rob Bovey 4.9 out of 5 stars (19)  £30.39

VB.NET Language Pocket Reference (Pocket Reference (O'Reilly)) by Steven Roman £5.99

› Explore similar items

Product Description
Why program Excel? For solving complex calculations and presenting results, Excel is amazingly complete with every imaginable feature already. But programming Excel isn't about adding new features as much as it's about combining existing features to solve particular problems. With a few modifications, you can transform Excel into a task-specific piece of software that will quickly and precisely serve your needs. In other words, Excel is an ideal platform for probably millions of small spreadsheet-based software solutions. The best part is, you can program Excel with no additional tools. A variant of the Visual Basic programming language - VB for Applications (VBA) - is built into Excel to facilitate its use as a platform. With VBA, you can create macros and templates, manipulate user interface features, such as menus and toolbars, and work with custom user forms or dialog boxes. VBA is relatively easy to use, but if you've never programmed before, Programming Excel with VBA and .NET is a great way to learn a lot very quickly. If you're an experienced Excel user or a Visual Basic programmer, you'll pick up a lot of valuable new tricks. Developers looking forward to .N ET development will also find discussion of how the Excel object model works with .NET tools, including Visual Studio Tools for Office (VSTO). This book teaches you how to use Excel VBA by explaining concepts clearly and concisely in plain English, and provides plenty of downloadable samples so you can learn by doing. You'll be exposed to a wide range of tasks most commonly performed with Excel, arranged into chapters according to subject - and those subjects correspond to one or more Excel objects. With both the samples and important reference information for each object included right in the chapters, instead of tucked away in separate sections, "Programming Excel with VBA and .NET" covers the entire Excel object library. For those just starting out, it also lays down the basic rules common to all programming languages. With this single-source reference and how-to guide, you'll learn to use the complete range of Excel programming tasks to solve problems, no matter what you're experience level is.

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

Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover

Search inside this book:

1 Review 5 star:    (0) 4 star:    (0) 3 star:    (0) 2 star:  (1) 1 star:    (0)           Average Customer Review 2.0 out of 5 stars (1 customer review)		Share your thoughts with other customers: Create your own review
Most Helpful Customer Reviews   2 of 2 people found the following review helpful: 2.0 out of 5 stars Dissapointed, 28 Oct 2008 By  Simon Duke-low "sdl187" (UK) - See all my reviews (REAL NAME)    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..... Comment Comment (1) | Permalink | Was this review helpful to you? Yes No (Report this) Share your thoughts with other customers: Create your own review › See all customer reviews...		Ad feedback   Search Customer Reviews Only search this product's reviews

Software Development: A list by Mr. J. B. Cox   Financial Market Stories: A list by London Banker "Bernardo"   football (soccer) betting: A list by T. Wright Create a Listmania! list

Search Listmania!

• Books > Computing & Internet > Digital Lifestyle > Online Shopping > Amazon
• Books > Computing & Internet > Microsoft Windows > Applications > Excel > Programming
• Books > Computing & Internet > Programming > Languages > Visual Basic
• Books > Computing & Internet > Programming > Microsoft Windows > .Net
• Books > Computing & Internet > Programming > Microsoft Windows > Excel
• Books > Computing & Internet > Software & Graphics > Business & Home Office > Spreadsheets > Microsoft Excel

• Would you like to update product info or give feedback on images?
• I am the Author, and I want to comment on my book.
• I am the Publisher, and I want to comment on this book.