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 Applications
You can create three different types of applications from within Excel. Which type you choose determines how the application is used and distributed:
- Workbooks
Package code as part of a unique document. The code is stored with the workbook file (.xls) and is available whenever the user opens that file in Excel. If the user copies the file, the code is copied along with the rest of the workbook.
- Templates
Include code as part of a template for new Excel workbooks. When a user creates a new workbook file (.xls) from the template (.xlt), the code contained in the template is available in that new workbook though the code is not actually copied to the workbook.
- Add-ins
Include code as a file that can be loaded into the Excel application. If a user loads an add-in file (.xla), code from that add-in is available for any workbook a user opens.
Table 6-1 describes the relative advantages of these different types of applications.
Table 6-1. Ways to distribute code in Excel
|
Code stored in |
Available to |
Advantage |
Disadvantage |
|---|---|---|---|
|
Workbook (.xls) |
Currently loaded workbooks |
No installation required; easy to distribute. |
Updates are difficult because the workbooks may be copied/renamed and there’s no way to merge new code. |
|
Template (.xlt) |
Workbooks based on the template |
Single file; code applies to specific type of workbook. |
Templates must be installed. |
|
Add-in (.xla) |
All workbooks |
Single file; code most widely available. |
Add-ins must be installed; don’t include ... |
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.