April 2006
Beginner
1114 pages
98h 16m
English
Content preview from Programming Excel with VBA and .NETBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
What’s in This Book
Chapters in this book are organized by programming task. I cover the most common tasks for each subject within a chapter. Subjects usually correspond to one or more Excel objects, and I include important reference information for those objects within each chapter, rather than pushing that information to the back of the book.
Tip
I don’t expect this book will be your only resource, and I try not to duplicate stuff you already have (like online Help), so I include cross-references to other sources. I’ve also included those resources as hyperlinks in the sample workbooks (see the Resources sheet). Mostly, those links deal with much more specific issues related to the topic, but they also include links to toolkits and other software you may need.
Here is a brief overview of each chapter:
Chapter 1, Becoming an Excel Programmer, is meant for those new to Excel programming. It covers how to record, change, run, and debug code in the Excel Visual Basic Editor. Experienced Excel programmers can skip this chapter, although they may want to read the section "Write Bug-Free Code.”
Chapter 2, Knowing the Basics, explains the parts of a program: classes, modules, procedures, properties, events, variables, constants, and all the other programming fundamentals. Experienced programmers might want to skip right to “Objects” and “Exceptions” in this chapter.
Chapter 3, Tasks in Visual Basic, teaches how to use core Visual Basic features to display simple dialog boxes, perform calculations, ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.