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 Add-ins
From a user’s perspective, an add-in is a file that you load by selecting Tools → Add-ins from within Excel. Add-ins extend Excel in some way and usually display a toolbar or add menu items as a way to get at their features.
Table 22-1 lists the add-ins that ship with Excel. There also are many free sample add-ins available by searching http://office.microsoft.com/ for “Excel add-ins.”
Table 22-1. Add-ins installed with Excel
|
Add-in |
Provides |
Adds menu item |
|---|---|---|
|
Analysis ToolPak |
Advanced functions for financial and scientific data analysis |
Tools → Data Analysis |
|
Analysis ToolPak VBA |
Support for using the Analysis Toolpak functions from Visual Basic |
None |
|
Conditional Sum Wizard |
Formulas to sum data in lists |
Tools → Conditional Sum |
|
Euro Currency Tools |
Conversion and formatting for the Euro currency |
Tools → Euro Conversion |
|
Internet Assistant VBA |
Support for saving worksheets as HTML from Visual Basic |
None |
|
Lookup Wizard |
Wizard to help create formulas to find value in a range |
Tools → Lookup |
|
Solver |
What-if analysis of data |
Tools → Solver |
From a developer’s perspective, add-ins are Excel applications without a worksheet interface. Instead, add-ins act on objects in the currently loaded workbook. There are two main types of add-ins:
Code-only add-ins provide user-defined functions that can be used from Excel formulas or within Visual Basic.
Visual add-ins provide wizards or toolbars to help users performs specific actions.
Some add-ins combine these two types. ...
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.