Creating add-ins

[jomni]

How do you create add-ins?
I made several functions which I plan to use often and I don't
want to copy or import the Modules to every workbook I'm
working on. It seems that if I make an add-in, the functions
will be usable in every workbook.

 

[William]

jomni

you could start here...
http://support.microsoft.com/defaul...port/kb/ARTICLES/Q156/9/42.asp&NoWebContent=1

--
XL2002
Regards

William

(e-mail address removed)

| How do you create add-ins?
| I made several functions which I plan to use often and I don't
| want to copy or import the Modules to every workbook I'm
| working on. It seems that if I make an add-in, the functions
| will be usable in every workbook.
|
|
| ---
| Message posted
|

 

[Norman Harker]

Hi Jomni!

Open a new workbook.
Copy and paste your VBA code to modules in this new workbook
Delete all except one worksheet
File > Save As
Give a file name without any extension
From the File Type drop down select "Microsoft Excel Excel Addin"
[It's right down the bottom]
OK

The best place to store the Addin will be in the Library file. This is
variously located but here's a typical location:

C:\Program Files\Microsoft Office\Office2003\OFFICE11\Library

If you put it there, Excel will read it into the Addin dialog the next
time Excel is opened (note that you won't see it there immediately
after saving from within Excel and you have to close and re-open
first).

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.