where to get information about excel add-in

[watchdog]

Hi all,

when i read excel-vba teach books, sometimes they would instruct to add an add-in. Where can I access information as of which add-in contains which particular ddl that can perform what.

thanks,

 

[schielrn]

Welcome to the Board!

Probably your best bet is just searching the web for the add-in and the associated dll. Anyone can create an add-in and if it is not Microsoft specific, not really sure if you will find anything specific?

 

[xenou]

Some addins (such as solver or the analysis toolpak) are probably on your machine already).

As Schielrn said, usually its as simple as:
1) Get the addin from the web or wherever
2) save it in your addins folder (see first link below)
3) "Install" it by checking the box for it in the addins dialog.


More on Installation:
http://www.cpearson.com/excel/InstallingAnXLA.aspx

For Excel 2007:
http://peltiertech.com/WordPress/installing-an-add-in-in-excel-2007/

Excel 97 and above:
http://www.dslimited.biz/excel_tutorials/installadd-in.html (some screenshots of the dialog box here)

Unfortunately there's more than one place to put these files - but I like to just do a search for files with .xla extensions (or .xlam in 2007) and find where they are that way.