April 2006
Beginner
1114 pages
98h 16m
English
Content preview from Programming Excel with VBA and .NET
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,
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.
Types of Tasks
You can perform several broad categories of tasks with the Visual Basic language. Since we’re talking about Visual Basic (not Excel), these tasks tend to be very general. More specific tasks are usually handled through Excel objects.
I’ve organized this chapter so the simplest tasks are first. By the end, things get pretty advanced, so if you feel overwhelmed at any point, feel free to come back later—you may just need some time to digest these concepts. Table 3-1 organizes the sections in this chapter to give you a bit of an overview .
Table 3-1. An overview of Visual Basic programming tasks
|
Category |
Section |
Overview |
|---|---|---|
|
Users |
Interact with Users |
Use simple dialog boxes to get or display information. |
|
Data |
Do Math |
Perform calculations. |
|
Work with Text |
Compose and modify strings of text. | |
|
Get Dates and Times |
Get current dates and times and perform calculations on dates and times. | |
|
Storage |
Read and Write Files |
Open, read, write, and close files stored on disk. |
|
Expressions |
Check Results |
Find what kind of data was returned by an operation. |
|
Find Truth |
Combine expressions to create complex conditions. | |
|
Compare Bits |
Get multiple pieces of information from a single value. | |
|
Interoperate |
Run Other Applications |
Exchange data with other Windows applications. |
|
Compiler |
Control the Compiler |
Create debug and release versions of code within the same source file. |
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.