Skip to Main Content
Excel 2003 VBA Programmer's Reference
book

Excel 2003 VBA Programmer's Reference

by Paul T. Kimmel, Stephen Bullen, John Green, Rob Bovey, Robert Rosenberg
July 2004
Beginner content levelBeginner
1176 pages
27h 45m
English
Wrox
Content preview from Excel 2003 VBA Programmer's Reference

12

Creating and Using Add-ins

An Add-in is a chunk of code that is employed as a reusable augmentation to Excel. An Add-in might be implemented in a language like VB6 or more easily and commonly another Excel workbook containing some code that one might generally want to reuse. For example, it is practical and useful to reuse the DebugTools and EventLog modules from the Bulletproof.xls workbook in Chapter 7, so we might elect to add the Bulletproof.xls workbook to our list of Add-ins making it available to all future workbooks. In this chapter we will demonstrate how to make any workbook an Add-in, and as such, much more readily accessible to all workbooks.

Add-ins may but do not have to be compiled, external applications. However, since Office 2000 Developer Edition, support for compiling workbooks has been assisted. For more information on using compiled Add-ins refer to Chapter 13, Automation Add-ins and COM Add-ins.

In this chapter we will use the Bulletproof.xls workbook as an Add-in, and we will show you how to hide the implementation details of Add-in code to prevent it from being inadvertently changed by future consumers.

Hiding the Code

Workbooks are intellectual property. Workbooks used as Add-ins represent intellectual property that you may want to share or sell to other developers, but you may not necessarily want them to know the nuts and bolts of your solution. While you cannot prevent a consumer from knowing that your Add-in exists because it shows up in the Project ...

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.
Start your free trial

You might also like

Excel 2007 VBA Programming with XML and ASP

Excel 2007 VBA Programming with XML and ASP

Julitta Korol
Microsoft® Office Excel 2003 Programming Inside Out

Microsoft® Office Excel 2003 Programming Inside Out

Curtis Frye, Wayne S. Freeze, Felicia K. Buckingham
Excel® 2007 VBA Programmer's Reference

Excel® 2007 VBA Programmer's Reference

John Green, Stephen Bullen, Rob Bovey, Michael Alexander
Access™ 2007 VBA Programmer's Reference

Access™ 2007 VBA Programmer's Reference

Teresa Hennig, Rob Cooper, Geoffrey Griffith, Armen Stein

Publisher Resources

ISBN: 9780764556609Purchase book