Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

How do I create an excel add-in with VBA?

42 views
Skip to first unread message

KP

unread,
Jun 19, 2002, 4:21:23 PM6/19/02
to
I am just interested in learning how to create an excel
add-in using VBA, but I cannot seem to find any good
documentation anywhere. I have looked at 2 bookstores
and in MSDN, but all documentation that I have come
across is just about how to save a Workbook as an .xla
file, and does not have any more in-depth information.
Can anyone suggest a useful book or reference for me?


Tom Ogilvy

unread,
Jun 19, 2002, 11:41:04 PM6/19/02
to
If you aren't talking about COM addins (compiled addins) there may be some
useful information in these:

ADDINS:

http://msdn.microsoft.com/library/backgrnd/html/msdn_addins97.htm
Distributing Microsoft Excel 97, Word 97, and PowerPoint 97 Solutions


http://msdn.microsoft.com/library/techart/XLCrAddns.htm
Creating Add-ins in Microsoft Excel 97


http://www.microsoft.com/exceldev/tips/addins.htm
Protecting the Code in an Add-in

http://msdn.microsoft.com/library/officedev/odeopg/deovraddinstemplateswizar
dslibraries.htm
Chapter 11, VBA Programmer's Guide

http://msdn.microsoft.com/library/officedev/office97/SFE49.htm
Installation

http://msdn.microsoft.com/library/officedev/office97/SFA96.htm
The Microsoft Excel Subkey


Extract from:
http://msdn.microsoft.com/library/backgrnd/html/msdn_ofc97enh.htm

Enhanced functionality for add-ins
-Easier distribution of Add-Ins. AddinPath registration key allows you to
set up the user's machine to find your Add-in without having to put your
Add-in in the System directory.

-Simplified development and debugging of Add-ins. Add-ins are just workbooks
with special properties now. You can debug and save your Add-in while the
Microsoft Excel application treats it like a full fledged Add-in.

-Event handlers that fire for all workbooks. These event handlers will
typically be stored in Add-ins.

-"Make AddIn" command and add properties. These properties have been
included to enable fine control over what makes an Add-in.


KP <klpa...@yahoo.com> wrote in message
news:1015701c217ce$e1949c70$b1e62ecf@tkmsftngxa04...

0 new messages