O'Reilly Media, October 2009
Why program Excel? For solving complex calculations and presenting results, Excel is amazingly complete with every imaginable feature already in place. 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 .NET 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, with those subjects corresponding 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.
$27.29 List price: $43.99 You save: 38% ($16.70)
If you use one of Kobo's free reading apps you won't need to worry about download options most of the time. Your Kobo reading app can easily add Kobo Store books to your library for a seamless reading experience.
Download options matter when:
In both of these cases you will need to:
You can also use Digital Editions to transfer the book to your eReader. See here for more information on Digital Editions.
You can read this item on your computer using our free Kobo Desktop Application. This application lets you read, manage your library of eBooks, and even shop for new ones. Check out our demo for more information!
Learn More »You can read this item on your Kobo eReader (or other select electronic reading devices). The Kobo eReader lets you carry your whole library with you, so that you can read on the go.
Visit kobo.com/ereaders »You can read this item on select tablets using one of our free Kobo apps. These apps let you read, manage your library of eBooks, and even shop for new ones.
Learn More »You can read this item on your Kobo Arc using the Library app. This app lets you read, manage your library of eBooks, and shop for new books.
Learn More »You can read this item on any Android device (phone, tablet) with one of our free Kobo apps. These apps let you read, manage your library of eBooks, and even shop for new ones.
Learn More »You can read this item on the free Kobo app for iPhone. This app let you read, manage your library of eBooks, and even shop for new ones.
Download the iPhone App! Learn More »
By: {2}
Available on: {3}
Coming soon
Secure TransactionSubtotal
Store Credit
Total
We'll charge your credit card {4} on {3}.
We'll charge your credit card {4} when the book is added to your Library.
Your store credit covers the cost of this purchase, so we don't charge your credit card
Use Quick Buy for all eBook purchases.{2} is now in your library. You'll receive an email confirming your purchase very soon.
{2} has been pre-ordered. You'll receive a confirmation email confirming your pre-order very soon.
You were charged:
You will be charged: on {3}
You will be charged: when the book is added to your Library
Rakuten Super Points earned: {1}
Rakuten Super Points {1} earned after the book is added to your Library
